Remove first few digits from all cells in the column

[Magwine]

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.

 

[Mike H]

try,

=MID(A1,4,999)

Mike

 

[John Bundy]

just noticed that mid had an error
=MID(A1,4,LEN(A1)-3)

 

[John Bundy]

a couple options:
=RIGHT(A1,LEN(A1)-3)
or
=MID(A1,3,LEN(A1)-2)

 

[Teethless mama]

Try this:

=REPLACE(A1,1,3,"")

 

[T. Valko]

Much more fexible:

=MID(A1,FIND(" ",A1)+1,255)

 

[Beege]

You could use Text to columns, with ". " (that's dot space)as a
delimiter, and not select the left side to convert.

Beege

 

[Beege]

Sorry, only one delimiter per customer.... and if you use dot, it leaves
a space in front of the name. My bad.

Beege