As you need to have a comma after an item to separate it into the next
column, so first replace "Mrs. " (plus the space after the s dot) with
"Mrs.," and once that is done do what you were doing before. Hope that
helps.

Brian

"Deena at DCH FD" wrote in message
...
Thank you. Do you have any advice on separating out "Dr. & Mrs. Smith"
into
2 columns. ie: cell a1=Dr. & Mrs. cell b1=Smith

I've been playing around with using a "." as the separator, but it splits
the cell into 3 columns...

"JMB" wrote:

click Data/Text To Columns
click Delimited
Check Comma (unchecking any other delimiters that may be checked)
click Finish

Backup before trying

"Deena at DCH FD" wrote:

I have an excel spreadsheet with first and last name in the same
column.
ie:smith,jon. I need to have the last name in one column and the first
name
in the next.

How can use .csv to break this into 2 separate columns: cell a1=smith,
cell
b1=jon

(I don't know anything about using 'comma separated values' so any
detail
info would be greatly apprecaited!