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.

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.

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.

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.

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.

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.

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.

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.