Hello everybody,
I have addresses entered as in below in several rows. Note that the
entire address for each individual is put in a single cell as text. All
cells have commas though and "text to column" option is completely
ruled out. There are about 50000 such entries and they do not contain
words in fixed order. For instance, in the following example, say the
rows are in rows B1 to B1000, I wish to place a formula in C1 to C1000
and find if the corresponding cell in B1 to B1000 has the word "Taluk"
and if so, to also read the word or words before "Taluk" - all occuring
until a comma and then to copy the entire set of words in C1 to C1000.
Kempapura, Hasigala Post, Hoskote Taluk, Bangalore Rural
Upparahalli, Kumbalahalli Post, Hona Hoskote Taluk, Bangalore Rural
Dist. Pin. 562114
#42/10, Suresh Nilaya, Behind Dharmaraya Temple, Malinapet, Taluk,
Bangalore
J 36, Pipline Malleshwaram, Ganesha Block, Bangalore
Taluk,Viveknagar II stage, Sulibele Road, Bangalore Rural Dist
This is what I a single formula to accomplish :
In row 1 below, I need to get "Hoskote Taluk"
In row 2 below, I need to get "Hona Hoskote Taluk"
In row 3 below, I need to get "Taluk"
In row 4 below, I need to get nothing
In row 5 below, I need to get "Taluk"
Kempapura, Hasigala Post, Hoskote Taluk, Bangalore Rural
Upparahalli, Kumbalahalli Post, Hona Hoskote Taluk, Bangalore Rural
Dist. Pin. 562114
#42/10, Suresh Nilaya, Behind Dharmaraya Temple, Malinapet, Taluk,
Bangalore
J 36, Pipline Malleshwaram, Ganesha Block, Bangalore
Taluk,Viveknagar II stage, Sulibele Road, Bangalore Rural Dist
All support is appreciated.
DHANANJAY
Bookmarks