| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove first few digits from all cells in the column
Sorry, only one delimiter per customer.... and if you use dot, it leaves
a space in front of the name. My bad. Beege Beege wrote: You could use Text to columns, with ". " (that's dot space)as a delimiter, and not select the left side to convert. Beege Magwine wrote: 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
