formula

[singkit]

please help me build formula. that will separate once it
reads alphabet


e.g.

column a column b
[email protected] [email protected]
[email protected] [email protected]
4545 ext. 4546 ext. 4546

Thanks!

 

[Jason Morin]

See my response to your original post.

HTH
Jason
Atlanta, GA

 

[Juan Sanchez]

singkit

=MID(A1,MIN(IF(ISNUMBER(--(MID(A1,ROW(INDIRECT("1:"&LEN
(A1))),1))),"",ROW(INDIRECT("1:"&LEN(A1))))),LEN(A1))

Array formula, instead of enter use CNTRL+SHIFT+ENTER..

Regards
Juan