removing leading numbers

[zugfrig]

HI

i am using a form to get an email for a list of preferred names.

the list comes back to me in the order that the user has chosen but it has leading numbers on it (see below)

is there a formula i can run to cut off the leading number, the : and the blank space so that the first character is the persons name?




1: Trent Cotchin would be Trent Cotchin
2: Aaron Sandilands
3: Adam Saad
4: Alex Rance
5: Bernie Vince
6: Blake Hardwick
7: Brad Crouch
8: Brodie Grundy
9: Anthony McDonald-Tipungwuti
10: Callan Ward
11: Cameron McCarthy
12: Charlie Cameron
13: Christian Petracca
14: Connor Menadue
15: Cyril Rioli
16: Jack Macrae
17: Daniel McStay
18: Daniel Rich
19: Daniel Wells
20: Darcy Moore
21: David Armitage
22: Easton Wood
23: Jack Martin
24: Jack Riewoldt
25: Jack Silvagni
26: Jake Carlisle
27: Jake Stringer
28: Jeremy Cameron
29: Jesse Hogan
30: Jordan Roughead

 

[L. Howard]

One way...

=TRIM(MID(A2,FIND(" ",A2),44))

Then select the column and copy > paste values to get rid of the formulas.

Howard

 

[zugfrig]

One way...

=TRIM(MID(A2,FIND(" ",A2),44))

Then select the column and copy > paste values to get rid of the formulas.

Howard

PERFECT Thankyou

 

[L. Howard]

You're welcome, thanks for the feed back.

Howard