formatting the cells.

  • Thread starter Thread starter faddrickremo
  • Start date Start date
F

faddrickremo

Hello ,
Can somebody help me in solvin the follwoing problem...
I have a excel sheet which has 10000 customer's
information but not formatted in the sense
name,age,employment together in one cell.
excample name :vvvvvv,age 23,employment : xxxxx linc...

i wanted to seperate it into different columns.
and i wanted to put it in a table format like below
name age employment
vvvvv 23 xxxxx


i tried using text to coulmns option but it didnt give me
a correct result.
can somebody help me.

Bye
faddrick
 
faddrickremo said:
Hello ,
Can somebody help me in solvin the follwoing problem...
I have a excel sheet which has 10000 customer's
information but not formatted in the sense
name,age,employment together in one cell.
excample name :vvvvvv,age 23,employment : xxxxx linc...

i wanted to seperate it into different columns.
and i wanted to put it in a table format like below
name age employment
vvvvv 23 xxxxx


i tried using text to coulmns option but it didnt give me
a correct result.
can somebody help me.

Bye
faddrick
Click to expand...

What result did it give, and what were you expecting? It works for me on
your sample data. At the first stage of the wizard, you need to select
'delimited' rather than 'fixed width'. Then, at the next stage, check
'comma' and uncheck anything else as the separator.
 
Dear Paul,
Thanks for your help.
Actually the datas i have, dont have any commas or spaces
and more over all the fields like name,age are together
and broken into 2 or 3 different rows.
i wanted to seperate it and put it in a table format.

the sample data is as follows.
name ddddd last pd date 12/10/2003
age 23 employee ffffff employer fghfghfgh.

the result what iam expecting is as follows.
name lastpddate age employee employer
dddd 12/10/2003 23 fffffff fghfghfgh.

can u help me in solving this problem?
Bye
Faddrick.




..
 
Back
Top