seperating data from one cell to multiple cells?

[Guest]

Hi,
I have a worksheet open that has 250 rows of data, all the data appears in
one cell and is seperated by commas, can anyone tell me how I can get excel
to seperate the data divided by commas into individual cells, having seperate
columns?
Without having to do it one at a time using copy and paste?

 

[Guest]

Go to 'Data' menu and select Text to Column.
Select 'Delimited' and then select 'Comma' as the delimeter.

This should solve your problem.

 

[Guest]

Pranav, thank you so much, that worked.

Could I ask you one more question?
When I have phone numbers in a column and I wish to remove duplicates, how
would I do that?

Thank you so much for your help and for answering me back so quickly ;-)

 

[Bob Phillips]

In a helper column, add a formula like

=COUNTIF(A$1:$A2,A2)>1

and copy down, then filter (Data>Filer>Autofilter) that column and select
all items >1 and delete all visible rows other than the header.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Guess I'm just not too savy with excel, could you please tell me what a
"helper Column" is and I don't quite understand the formula.
I have a list of phone numbers in Column A down to the 3646 row, there are
duplicates of many of the different phone numbers, and I wish to remove the
duplicates, including the rows. I guess I really need step by step
instructions.

Thank you so much...

 

[Bob Phillips]

A helper column is just a term for spare column in your worksheet that you
add a formula in to help you achieve your objective, a step in the process.

In my suggestion, the helper column is used to add a formula that counts the
instances of the current value in A, up to and including that row, returning
TRUE or FALSE. The first instance of a value will return FALSE, second and
subsequent values will return TRUE.

If you add that formula and copy down all applicable rows, then filter by
the helper column, you will see all the duplicate date. Select all rows
except the header row, then you can just hit Delete to remove them. Then
turn off the filter, delete the helper column, and your data is good.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)