Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/09/18
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer this question.

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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

Atif Tanveer
by 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
by 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
by 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
by 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.

Deleted user
by Deleted user

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
by 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
by 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
by 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