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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 08, 2025

As variant

=LET(
  split, TEXTSPLIT(A1," "),
  CONCAT( TEXT( TAKE(split,,1), "0000"), LEFT( DROP( split,, 1) ) )
)