Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
find and replace | Excel Discussion (Misc queries) | |||
Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |