If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|