VBA to remove characters until first letter?

[Coyotex3]

Hello guys, This one has me stumped. I'm trying to create a code that will allow me to remove all the characters up to the first letter found.

Here is what the original data looks like on Column A and the Expected Results in Column C

Book3
	A	B	C
1	1001-OO-Boom		OO-Boom
2
3	1005-AA-Bang		AA-Bang
4
5	1009 - AA-Boom Bang		AA-Boom Bang
6
7	1002 - EE-Boon		EE-Boon
8
9	0099-II-Been		II-Been
10
11	1001-OO-Boom		OO-Boom
12
13	1005-AA-Bang		AA-Bang
14
15	1009 - AA-Boom Bang		AA-Boom Bang
16
17	1002 - EE-Boon		EE-Boon
18
19	0099-II-Been		II-Been
20
21	1001-OO-Boom		OO-Boom
22
23	1005-AA-Bang		AA-Bang
24
25	1009 - AA-Boom Bang		AA-Boom Bang
26
27	1002 - EE-Boon		EE-Boon
28
29	0099-II-Been		II-Been
Sheet1

Any ideas on the best way to achieve this?

 

[steve the fish]

Heres a possible assuming always the - between.

=IFERROR(TRIM(MID(A1,FIND("-",A1)+1,99)),"")

 

[keef2]

This seems to work =(RIGHT(B1,LEN(B1)-FIND("-",B1)))

 

[Fluff]

Another option if you have the new functions

=IF(A1="","",TEXTAFTER(A1,"-",1))

 

[steve the fish]

Another option if you have the new functions

=IF(A1="","",TEXTAFTER(A1,"-",1))

First ive seen of that one! You should trim it too looking at the data.

 

[keef2]

Another option if you have the new functions

=IF(A1="","",TEXTAFTER(A1,"-",1))

Fluff on it again. I wish I knew all the new functions like you!!! Thanks for sharing

 

[Fluff]

You should trim it too looking at the data.

Good point, missed that some had spaces after the -

=IF(A1="","",TRIM(TEXTAFTER(A1,"-",1)))

 

[Coyotex3]

Heres a possible assuming always the - between.

=IFERROR(TRIM(MID(A1,FIND("-",A1)+1,99)),"")

This one works in getting me what I want. Thank you!

 

[Coyotex3]

This one works as well, this one show "#Value" if the cells are empty.

 

[Coyotex3]

Good point, missed that some had spaces after the -

=IF(A1="","",TRIM(TEXTAFTER(A1,"-",1)))

Was able to use this one as well!


Thank you all for the help!