Hi all.
Have a column of cells filled with item descriptions separated by the | symbol.
How can I get the values separated by | into new separate cells?
Please see attached highlighted column
Hi all.
Have a column of cells filled with item descriptions separated by the | symbol.
How can I get the values separated by | into new separate cells?
Please see attached highlighted column
Have you tried text to columns?
Ben Van Johnson
Hi,
If I understand correctly, use this formula in Z2 copied down and across as far as needed:
=TRIM(MID(SUBSTITUTE($Y2,"|",REPT(" ",LEN($Y2))),COLUMNS($Z2:Z2)*LEN($Y2)-LEN($Y2)+1,LEN($Y2)))
Mmmm close except the other half of the original cell needs to be moved to cell AA2 "Extra soft and comfy for a great sleep".
If there is multiple breaks in the original cell then a 3rd or 4th column would be needed based on the total |
If you're talking to me...
That's what my formula does. Did you change something within the formula?? And, did you read my post telling you to copy the formula DOWN and ACROSS as far as needed??
Download the file in my post #3 and see for yourself.
Edit: I've re-uploaded the file, download it from this post. No change in formula, same as Post #3.
Last edited by jtakw; 06-26-2018 at 09:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks