Forum Discussion
Excel formula help please
I need information on how to extract the exact state from the middle of the address using a formula in a separate column.
Hi, do you have a list of the states, or is the information in the cells separated by commas or something similar? Can you show an example of an address cell?
Please see my example. It may already be working.
=XLOOKUP(TRUE,ISNUMBER(XMATCH("*"&B$2:B$14&"*",A2,2)),B$2:B$14,"")