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.
:-)
|