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

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

متابعة

By which formula, can we get the data of few cells/rows/columns in 1 single cell/row/column? The data should not change in term of value.

user-image
تم إضافة السؤال من قبل Asheesh Kumar , Accounts & Finance Manager , Prayagraj Smart City Limited
تاريخ النشر: 2013/05/11
Ansab Khan
من قبل Ansab Khan , AVP / Unit Head - Digital HR Solutions , Meezan Bank Ltd

as far as i have understand your question, you are asking to merge value into one cell, this can be done through "concatenate function" by using &.
For you want to merge a1 and b1 then your formula in c1 would be like =a1&b1 this would be appeared without space, with space formula would be like =a1&" "&b1 i hope you will find this helpful

Padmavathi Duvvuri
من قبل Padmavathi Duvvuri , HR Generalist , Banka Bioloo Private Limited

Conacatenate function can be used or an ampersand(&) can be used in place of concatenation.

=Concatenate(A1," ",B1)

=A1&", "&B1

Muhammad Jawad
من قبل Muhammad Jawad , Senior Recruitment Analyst , SWI Inc.

If you are asking about MS Excel then you should use VLOOKUP formula to get your desired results

Mike Emerson Pasaron
من قبل Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

try using concatenate function or &

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