| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find & and delete everything following
Hi There,
I have a spreadsheet with names in one column, however to load this file I need to format correctly. EG column contains: James Smith & Sarah Brown I need to delete everything from '&' onwards. (I have used text to columns using & as the delimiter, however there are instances of three or four names!) Is there are delete function I can use? Could you please help? Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and delete | Excel Worksheet Functions | |||
| Find and delete! | Excel Discussion (Misc queries) | |||
| Find and Delete | Excel Worksheet Functions | |||
| find a value and delete that row | Excel Discussion (Misc queries) | |||
| Find delete | Excel Discussion (Misc queries) | |||
Threaded Mode
