Excel Jululian
 

Good morning

please help

i have a lists of names and i want to separate each in a colum like

You Light Up My Life197711

You Light Up My Life (in one colum "A")

1977 (in one colum "B")

1 (in one colum "C")

1 (in one colum "E")

regards

Excel Jululian
 

First many thanks on your reply

the text are different in length

regards

"מיכאל (מיקי) אבידן" wrote:

'Data' 'Text to Columns' 'Next' mark/un-mark the vertical separators as
shown in the picture 'Finish'
http://img220.imageshack.us/img220/5826/nonamee.png
Micky


"George A. Jululian" wrote:

Good morning

please help

i have a lists of names and i want to separate each in a colum like

You Light Up My Life197711

You Light Up My Life (in one colum "A")

1977 (in one colum "B")

1 (in one colum "C")

1 (in one colum "E")

regards

Excel Jululian
 

Many thanks on your support

"מיכאל (מיקי) אבידן" wrote:

It is, usually ,essential to provide the whole details in order to eliminate
useless posting.
*** Column "C" can be Hidden - not deleted ***
http://img406.imageshack.us/img406/4456/nonameqf.png
Micky


"George A. Jululian" wrote:

First many thanks on your reply

the text are different in length

regards

"מיכאל (מיקי) אבידן" wrote:

'Data' 'Text to Columns' 'Next' mark/un-mark the vertical separators as
shown in the picture 'Finish'
http://img220.imageshack.us/img220/5826/nonamee.png
Micky


"George A. Jululian" wrote:

Good morning

please help

i have a lists of names and i want to separate each in a colum like

You Light Up My Life197711

You Light Up My Life (in one colum "A")

1977 (in one colum "B")

1 (in one colum "C")

1 (in one colum "E")

regards