problem splitting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used the 'text to column' function to split data in a column to multiple columns. However, only the data before the first delimiter was copied to a new column. The data after that didn't split to other columns. Can someone help me with this

Thanks a million.
 
I found out why it wasn't working for me. It was because my data in each cell is displayed in split into multiple lines, with one piece of information on each line. When I deleted the space between the lines and using delimiters to separate the pieces of information, it worked!

Hope this helps whoever needs this information in the future.
 
Back
Top