Split Text List Into Individual Cells

[DougStroud]

I have a text list copied from the clipboard that pasted everything into one cell. I would like to split the individual records into their own cells, in the column. The records are separated by a comma. Here is a short example of the text list:

0025_Billette_John_Wedding__S516914, 0029_Billette_John_Wedding__S516940, 0041_Billette_John_Wedding__S528265



Thanks for the help!

 

[DougStroud]

sorry... grabbed the wrong file and didn't inspect it. Try it again- I have corrected it. https://stroudimages.photoshelter.com/gallery-image/Excel/G0000x0s9sNZe.5M/I0000e8sl238ldw4

 

[jtakw]

Based on just the screenshot, I can't see a reason for the error (are you able to do Text to Columns with the same data?), if you want me to investigate the cause, please upload sample file to a free file sharing site of your choice, something like Dropbox, and post the link here.