Microsoft Office Forums - View Single Post - Split column at a particular character

Thread: Split column at a particular character

View Single Post

Old

05-10-2018, 11:11 AM

slaycock

slaycock is offline

slaycock uses Windows 7 64bit

Windows 7 64bit slaycock uses Office 2016

slaycock uses Office 2016

Office 2016

Expert

Join Date: Sep 2013

Posts: 255

slaycock is on a distinguished road

Default

Yes. Convert the whole table to text. Then convert text to table using '|' as the character that marks columns.

Reply With Quote