| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
try,
=MID(A1,4,999) Mike "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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
just noticed that mid had an error
=MID(A1,4,LEN(A1)-3) -- -John Please rate when your question is answered to help us and others know what is helpful. "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
a couple options:
=RIGHT(A1,LEN(A1)-3) or =MID(A1,3,LEN(A1)-2) -- -John Please rate when your question is answered to help us and others know what is helpful. "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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
Try this:
=REPLACE(A1,1,3,"") "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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
Much more fexible:
=MID(A1,FIND(" ",A1)+1,255) -- Biff Microsoft Excel MVP "Magwine" wrote in message ... 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove first few digits from all cells in the column
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. |
|
#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. |
| Reply |
| 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 | |||
Hybrid Mode
