Forum Discussion

Excelwizz123's avatar
Excelwizz123
Copper Contributor
Jan 07, 2025

Extracting Text

Hi, for the life of me I cannot work out a way to extract the text I need,    I have an address eg. "2 Birch Court" and I want to extract the text to the format of "002BC"  But these addresses cha...
excel
Harun24HR's avatar
Harun24HR
Silver Contributor
Jan 07, 2025

If you have access to REGEX functions then could try-

=TEXT(REGEXEXTRACT(A1,"[0-9]+"),"0000")&REGEXREPLACE(A1,"[^A-Z]","")