| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I WANT THE MULTI CELL DATA IN ADDRESS FORM OR IN ONE CELL
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I WANT THE MULTI CELL DATA IN ADDRESS FORM OR IN ONE CELL
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 "farhan" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) | Excel Discussion (Misc queries) | |||
| how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
| how do i seprate multi data cell into 2 or more cells | New Users to Excel | |||
Hybrid Mode
