First character in a cell beginning with a alpha character

[MrDil]

Hi all.

I'm looking for a formula that will read a cell and find the first alpha character and everything after it. For example '123target' would be 'target' , or 'target123' would be 'target123' . I hope that makes sense. Any help would be appreciated!!! Thanks.

 

[Scott Huish]

Book3
	A	B
1	123target	target
2	target123	target123
3	bee45678	bee45678
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=MID(A1,MIN(LET(x,CHAR(64+SEQUENCE(26)),FIND(x,UPPER(A1)&x))),255)

 

[Rick Rothstein]

Using @Scott Huish's set-up, this single formula will spill the entire column's results...

=MID(A1,LEN(TEXTBEFORE(A1:A3,CHAR(SEQUENCE(26,,65)),,1))+1,LEN(A1))

 

[Peter_SSs]

Using @Scott Huish's set-up, this single formula will spill the entire column's results...

=MID(A1,LEN(TEXTBEFORE(A1:A3,CHAR(SEQUENCE(26,,65)),,1))+1,LEN(A1))

Wouldn't that need to be ..?

=MID(A1:A3,LEN(TEXTBEFORE(A1:A3,CHAR(SEQUENCE(26,,65)),,1))+1,LEN(A1:A3))

 

[MrDil]

Book3
	A	B
1	123target	target
2	target123	target123
3	bee45678	bee45678
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=MID(A1,MIN(LET(x,CHAR(64+SEQUENCE(26)),FIND(x,UPPER(A1)&x))),255)

PERFECT!!! thanks so much!

 

[MrDil]

PERFECT!!! thanks so much!

OK... One more scenario... How would I remove ALL numbers from the cell instead of just removing it from the beginning? Sorry to be a pain, I'm just thinking.

 

[Fluff]

How about

=CONCAT(TEXTSPLIT(A2,SEQUENCE(10,,0)))

 

[MrDil]

How about

=CONCAT(TEXTSPLIT(A2,SEQUENCE(10,,0)))

works great. thank you!!!

 

[Fluff]

Glad we could help & thanks for the feedback.