Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi - need help again... I have a large worksheet with a column for first
name and a column for last name. Within the column for first name, some of the names include a middle initial or middle name. I need to remove all but just the first name - there are over 3000 names and I don't have time to manually do this task. Is there a way to block the whole column and have excel remove anything after the space following the first name? Thanks! -- Cali Gal Native of Sacramento |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing formatting | Excel Discussion (Misc queries) | |||
Formatting Rows of Data based on Column Data | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Removing unwanted data in a column | Excel Discussion (Misc queries) | |||
Removing formatting | Excel Discussion (Misc queries) |