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

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to validate characters within a string of data in aparticular cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Can I insert a picture depending on the contents of another cell? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Use worksheet name in one cell as part of reference in other cells 3
Split single cell data into multiple colums 3
changing the address of data in a cell 3
Partial cell protection? 1

Top