Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What do this function (=I9(cell address) &"-"&J9(cell address)) do in Excel?

This function works to combine the data of two cells in Excel.

user-image
Question ajoutée par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date de publication: 2013/09/18
Zafar Iqbal
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer this question.

Ahmed Maher allam
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

this is a concatenate equation if u have value1 in i9 and value2 in cell j9 so the answer will be1--2

Atif Tanveer
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

It will contatinate values in cell I9 and J9 in the target cell.

copy this =I9 &"-"&J9 in A1 then put some data in I and J9.

Mohammad Suleman Siddiqui
par Mohammad Suleman Siddiqui , Timekeeper Or Any One , Cape R.B. Hilton

The Formula (=I9(cell address) &"-"&j9(cell address)) joins several text strings into one text string. this formula works same as the formula "Concatenate" works. and you can put more than two text to concatenate the text. 

Surya Prakash
par Surya Prakash , Analyst , ADP India Pvt Ltd

& is a concatination operator. This adds 2 strings to one. Here value in I9 is concatinated with J9 with "-" between them.

Suhail Kazi
par Suhail Kazi , HR, Administrative Office Manager , Al Maha Real Estate

It concatenates data from two different cells.

This is called concatenate function in excel and the purpose is to combine the text in the two cells together.

Utilisateur supprimé
par Utilisateur supprimé

It is a substitute of concatenate formula. Above formula will write value of I9 (Cell reference) followed by "-" and then followed by value of J9 (cell Reference)

Shafaat Khan
par Shafaat Khan , Engineer , Saudi Binladin Group

Its simply combines data of two reffered cells, separating by any special character used between " ", even space.

Muhammad Ikram
par Muhammad Ikram , Financial Contorller , Sparq Systems Inc.

It will convert the data in two referenced cells into text with a space in between.

Noman Rahim ACCA
par Noman Rahim ACCA , Senior Accountant , Affiniax Partners - Member of Allinial Global (Formerly UHY Saxena)

It is simply the function to join two alphabet or digits easily which are in two different places

More Questions Like This