| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove first few digits from all cells in the column
I believe this has something to do with function LEFT or RIGHT in Excel.
Specifically, I want to take out the first two digits and a space (the numbers) in all cells of the column, making it names only. So, "1. Vince Higgs" would become "Vince Higgs" and "2. Joe Blow" would become "Joe Blow" I have no experience with macros and little with functions, but have been experiementing with simple functions like TODAY. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove and replace digits from a number | Excel Worksheet Functions | |||
| Excel 2002 : How to remove the digits from original reference ? | Excel Discussion (Misc queries) | |||
| Remove specific text from a column of cells | Excel Discussion (Misc queries) | |||
| Delete first two digits in column | Excel Worksheet Functions | |||
| How to set a column to accept only a specified number of digits | Excel Worksheet Functions | |||
Threaded Mode
