I need assistance with excel. I need to merge a list of names that are in different cells.. I figured that out.. =a1&" "&c1 etc... but I need to have each listing appear on a different line.. within the SAME Cell... like the following.... this is a list of thousands of names.
Bob
Smith
Agent
South Carolina
what I have appearing is:
Bob Smith Agent South Carolina.
Please let me know of any suggestions you might have.
You need to insert a "Line Feed" after each segment. A Line Feed is signified by the value: CHAR(10). You must also turn on WordWrap in affected cells.
Your formula would look like this:
where your data is in A1:D1
-----A--------B-----------C-----------------D-----------
1 | Bob | Smith | Agent | South Carolina |
=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1
will end up being:
Bob
Smith
Agent
South Carolina
Again, make sure WordWrap is turned on (Format>Cells>Alignment>WordWrap checked)
Copy and paste this formula as needed.
Good Luck
Bruce
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks