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