stripping numerics

[makinmomb]

1. Ashley Greene
2. Katherine Heigl
3. Evangeline Lilly
4. Charisma Carpenter
5. Sarah Michelle Gellar
6. Nina Dobrev
7. Keira Knightley
8. Natalie Portman
9. Megan Fox
10. Kate Beckinsale

Have this one a1 , need remove those numeric to arrive to

Ashley Greene
Katherine Heigl
Evangeline Lilly
Charisma Carpenter
Sarah Michelle Gellar
Nina Dobrev
Keira Knightley
Natalie Portman
Megan Fox
Kate Beckinsale

Formula on b1 drag down

[JohnTopley]

Try in B1

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

[AlKey]

in B1 and copy down

Please Login or Register  to view this content.

v	A	B
1	1. Ashley Greene	Ashley Greene
2	2. Katherine Heigl	Katherine Heigl
3	3. Evangeline Lilly	Evangeline Lilly
4	4. Charisma Carpenter	Charisma Carpenter
5	5. Sarah Michelle Gellar	Sarah Michelle Gellar
6	6. Nina Dobrev	Nina Dobrev
7	7. Keira Knightley	Keira Knightley
8	8. Natalie Portman	Natalie Portman
9	9. Megan Fox	Megan Fox
10	10. Kate Beckinsale	Kate Beckinsale

[makinmomb]

Thank you very much all

[Tony Valko]

Here's another one...

Data Range

	A	B
1	1. Ashley Greene	Ashley Greene
2	2. Katherine Heigl	Katherine Heigl
3	3. Evangeline Lilly	Evangeline Lilly
4	4. Charisma Carpenter	Charisma Carpenter
5	5. Sarah Michelle Gellar	Sarah Michelle Gellar
6	6. Nina Dobrev	Nina Dobrev
7	7. Keira Knightley	Keira Knightley
8	8. Natalie Portman	Natalie Portman
9	9. Megan Fox	Megan Fox
10	10. Kate Beckinsale	Kate Beckinsale

This formula entered in B1 and copied down:

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