Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Jululian | Excel Discussion (Misc queries) | |||
Excel Jululian | Excel Discussion (Misc queries) | |||
Jululian & Excel | Excel Discussion (Misc queries) | |||
Excel Jululian | Excel Discussion (Misc queries) | |||
Excel Jululian | Excel Discussion (Misc queries) |