LinkBack URL
About LinkBacks
In a cell I have Adams, John & Cindy. How can I separate them so that I have Adams in one cell, John in another and Cindy in another?
In a cell I have Adams, John & Cindy. How can I separate them so that I have Adams in one cell, John in another and Cindy in another?
Hi,
Is it always going to be formatted with 3 names, with a "," and "&"? Can it be something else? Could it be 8 names with comas for all but the last one? Might need more details than that
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Provide a good sample IF the data is not of a consistent form (as per Jdevil's reply)(
In one column I have a list of names, usually husband and wife. But some of the cell has just the husbands first a last name.
I'd like to be able to separate the last and first names into individual cells.
Sorry about not being able to supply a better example.
Last edited by rhall092957; 06-22-2017 at 02:58 PM.
We need a SMALL sample file.
How's this? Not sure if it uploaded?
In C2
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,",","/"),"&","/"),"/",REPT(" ",99)),(COLUMNS($A:A)-1)*99+1,99))
copy across
Awesome, it works fine. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks