How do i split data into individual cells

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

notepad file "open with" microsoft excel resulted in all data lumping into
one cell. Hence, is there any way i can split those strings of data into each
individual line.
i can provide files if needed.
 
Hi Kelly

Select column A>Data>Text to columns>Delimited>select delimiter>Finish

It is probable that you will need tab or space as the delimiter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split individual cells? 2
VBA Multiple Line handling with Split() 1
Split cells across multiple columns 1
splitting up information in a cell 1
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce 5
Text to columns 11
Splitting a delimited text 6
Split single cell data into multiple colums 3

Back
Top