I WANT THE MULTI CELL DATA IN ADDRESS FORM OR IN ONE CELL

  • Thread starter Thread starter farhan
  • Start date Start date
F

farhan

eg: the supplier have contact no. name, adress, country name are in different
cells. but i want all the data in one cell in next worksheet.

kindly resolve

mfh
 
Assuming your data is on Sheet1 in Row 2 starting in Column A...

=Sheet1!A2&"; "&Sheet1!B2&"; "&Sheet1!C2&"; "&Sheet1!D2

You didn't say what delimiter you wanted them separated by, so I used a
semi-colon followed by a space.

Rick
 
Back
Top