How to delete first name from a last name column

Giganews Newsgroups
Subject: How to delete first name from a last name column
Posted by:  PeterM (P_Mast…@msn.com)
Date: Fri, 17 Oct 2003

I have 386 customers in a spreadsheet, that for some reason show last
name and first name in the same column (column A) Column B shows the
first name again. In the first column A the last name and first name is
separated by a comma. How can I delete the first name and middle initial
in the first column A. Is there a way I can say, delete all after the
comma in column A? Actually, what I really like to do,  is to use all my
name and address list, for a mailing. I may be able to use the
information the way it is, with last name first, then a comma, and then
the first name and middle initial in the first column. I just don't know
how. That is why I thought I need to get rid of the first name and
initial, in the first column and use the second column for the first
name. In a mail merge. Is there a program I can buy that would do this
mail merge grabbing information from a spreadsheet for me? I'm using Win
XP and Office XP Pro

Replies