Forum Discussion
Looking to identify and move address info to another column from group of text
Hello, Below is my original post but I think my inquiry is not possible. Instead, would anyone know how to use a formula to identify a number is a group of text and then execute a text to column...
Thank you, Sergei! Much appreciate the time to add your thoughts!
Don, that's not a good solution if the solution at all, but that's all what i have in mind.
I modified pefious formulas a bit to avoid array ones:
This one finds position of last digit in post code assuming you have that 5-digits number in the string (and more chances to find compare to last number in the string)
=SEARCH(AGGREGATE(14,6,1*(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),5)),1),A1)+5When the address is extracted by MID as
=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),SEARCH(AGGREGATE(14,6,1*(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),5)),1),A1)+5-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")))no array formulas. Sample is attached