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 )
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 )