Formula to remove left most characters of a text string

[nightracer]

Hi I have a text string that is:

1. John Smith 27:03.2
29. Joe Public 28:04.6
105. Father Christmans 26:49.2

I simply need a formula to remove the left most characters so that I start at the name
i.e. removes 1.[space] and 29.[space] etc respectively

As can be seen, I have other decimal places in the string so cant use text to columns, and sometimes I need to remove 3 characters, sometimes 4, maybe 5.

Is there a simple formula that will leave me with:

John Smith 27:03.2
Joe Public 28:04.6
Father Christmas 26:49.2

Many thanks for any help.

 

[njimack]

Excel Workbook
	A	B
1	1. John Smith 27:03.2	John Smith 27:03.2
2	29. Joe Public 28:04.6	Joe Public 28:04.6
3	105. Father Christmans 26:49.2	Father Christmans 26:49.2
Sheet1

 

[Momentman]

The following should work(at least for the sample provided)

Excel 2013
	A	B	C
1	1. John Smith 27:03.2	John Smith 27:03.2	John Smith 27:03.2
2	29. Joe Public 28:04.6	Joe Public 28:04.6	Joe Public 28:04.6
3	105. Father Christmans 26:49.2	Father Christmans 26:49.2	Father Christmans 26:49.2
Sheet6

Cell Formulas
Range	Formula
B1	=MID(A1,FIND(".",A1)+2,100)
C1	=RIGHT(A1,LEN(A1)-FIND(".",A1)-1)

 

[nightracer]

Brilliant.

Many thanks both njimack and Momentman, just the job!

Thanks again
Nightracer

 

[Rick Rothstein]

Here is one more formula for you to consider...

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

If you are copying this formula down and some of the cells could be blank, then use this version of the formula instead...

=REPLACE(A1,1,FIND(" ",A1&" "),"")