Excel 97

[david]

I have "last name" "comma" "first name" in a column that I
imported from Quickbooks Pro 2003.

Is there a way to separate this into a column containing
"last name" and a column containing "first name"?
Thanks. D.

 

[Chip Pearson]

David,

See http://www.cpearson.com/excel/firstlast.htm for a variety of
methods.

 

[Jay]

I have "last name" "comma" "first name" in a column that I
imported from Quickbooks Pro 2003.

Is there a way to separate this into a column containing
"last name" and a column containing "first name"?

The easiest way I think is to select the column and use
Data >> Text to columns
Then choose "Delimited" to describe the column and "Comma" as the
delimiter.

 

[Guest]

Hi David

Select the column of data and then go to

Data>Text_to_Column

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- david wrote: ----

I have "last name" "comma" "first name" in a column that I
imported from Quickbooks Pro 2003

Is there a way to separate this into a column containin
"last name" and a column containing "first name"
Thanks. D