PDA

View Full Version : Solved: formulas help.



KK1966
12-28-2011, 03:01 AM
Hi, experts

Don’t know does it work or not for my questions, but wanna try if someone help/asked way to do.
Looking for a formulas to split out the address which is many difficultly what I doing now………
as I knowing it the formula can do but just one logic… how do change for multiple logic ? if ok that’s greatful for me.

=MID(A1,1,FIND({"AVE"},A1)-2) ( can someone help how do change multiple creteria )

macropod
12-28-2011, 03:59 AM
Hi KK1996,

You can't expect much help when we can't see the data. Besides, how would you propose to handle the address for someone who's address is:
1st Floor, St Andrews St, St Albans Sth

Bob Phillips
12-28-2011, 05:01 AM
Try this

=MID(A2,1,MIN(IF(ISNUMBER(SEARCH({"Ave","Road"},A2)),SEARCH({"Ave","Road"},A2)))-2)

array-entered

KK1966
12-28-2011, 07:05 AM
Try this

=MID(A2,1,MIN(IF(ISNUMBER(SEARCH({"Ave","Road"},A2)),SEARCH({"Ave","Road"},A2)))-2)

array-entered

hI, xLD

The formulas work pefect for me . thanks :yay :yay :yay :yay