Remove numbers from the beginning of a string (with blanke)

[GradyJ]

I am looking to do what should be dimple, but doesn't seem to work with RIGHT, LEFT or LEN formulas. I would like a formula that will take the following

2005 JOHNSON GEORGE

and return

JOHNSON GEORGE

Please help. Grady ray:

 

[KenWright]

Same format every time?

=RIGHT(A1,LEN(A1)-FIND(" ",A1)-1)

 

[GradyJ]

Re: Remove numbers from the beginning of a string (with blan

Unfortunately, that is bringing back the numeric - 2005, and not the text. Any other thoughts?

G

 

[Von Pookie]

If *not* the same format every time, this worked for me:

Book1
	A	B	C	D
1	2005JOHNSONGEORGE	JOHNSONGEORGE
2	135791SMITHTIM	SMITHTIM
3	59JONESDON	JONESDON
Sheet1

Formula in B1 is:
=MID(A1,FIND(" ",A1)+1,LEN(A1)-(FIND(" ",A1)-1))

and then just copied down.