| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim a cell that has names and address to only show name
I have quite a few cells that have alot of information in them eg surname,
christian name and address. I only need the surname and christian name in one cell. How can I do this? eg Smith Jones 123 Harper St Manly (A1). I need the cell to only show Smith Jones (B1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
| How do I show the address of hyperlink to another cell in Excel ? | Excel Discussion (Misc queries) | |||
| address help (similar to trim or transpose) | Excel Worksheet Functions | |||
| add email address to a list of names | Excel Discussion (Misc queries) | |||
| HOW DO I ENTER TWO NAMES IN ONE ROW FOR ONE ADDRESS FOR LABELS | Excel Discussion (Misc queries) | |||
Threaded Mode
