Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match a text
Hi,
I have 1 column which contains address and city name now i want a formula which shuold look for city name and shud return the same city in next col. This i can do using filters (which contains = XXX and i can put the values in the next col) but pls tell me how to do automatically using the formula. Would appreciate the quick response. Thanks in advance. Example : # 49, MG road, Chennai now I shud look for the string "Chennai" and shud put the value "Chennai" in B1 81, II cross, viveknagar, Hosur 123, ALS Nagar, Chennai 555, Kormangla, Chennai -Christ. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a Text match | Excel Discussion (Misc queries) | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
delete all text that match | Excel Worksheet Functions | |||
How to match two different cells text, if the text is not in the . | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions |