View Single Post
  #1   Report Post  
Nancy Babbitt
 
Posts: n/a
Default Find and Replace

I have a list of names that are written as Last, First.

I want to divide this up so that column A contains only the last names and
column B contains only the first ones.

I have tried doing find *,* It does "find" each name, but when I tell it to
replace with ,* or * all it does is give me the comma and asterisk or
asterisk.

I know this can be done because I have done it before, but I keep forgetting
how.

Please help!

Thanks.

:-)