Try this in E1:
=TRIM(MID(SUBSTITUTE($A1,",", REPT(" ",255)),COLUMNS($E1:E1)*255-254,255))
Try this in E1:
=TRIM(MID(SUBSTITUTE($A1,",", REPT(" ",255)),COLUMNS($E1:E1)*255-254,255))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks