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

[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

 

[Rick Rothstein \(MVP - VB\)]

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