Excel Jululian
in [General]
|
Prev: Access denied when running Excel from DOS prompt with runas comman
Next: Does anybody know why these two Excel files must be open in the sameprocess?
From: George A. Jululian on 24 Apr 2010 02:46 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
From: George A. Jululian on 24 Apr 2010 05:57 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
From: George A. Jululian on 24 Apr 2010 06:58
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 |