How do i split data into individual cells

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.
 
R

Roger Govier

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.
 
Top