Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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.

Microsoft Excel Data Center
user-image
Question added by Asheesh Kumar , Accounts & Finance Manager , Prayagraj Smart City Limited
Date Posted: 2013/05/11
Upvote (0) Views (14) Followers (1) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Ansab Khan
by Ansab Khan , Sr. Officer , Meezan Bank Limited

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

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

=Concatenate(A1," ",B1)

=A1&", "&B1

Muhammad Jawad
by 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
by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

try using concatenate function or &

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help