ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
تاريخ النشر: 2013/09/18
Zafar Iqbal
من قبل Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer this question.

Ahmed Maher allam
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Suhail Kazi , HR, Administrative Office Manager , Al Maha Real Estate

It concatenates data from two different cells.

OMAR AL-TAMIMI
من قبل OMAR AL-TAMIMI

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

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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
من قبل 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
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة