Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find in string
Hi! I have a long list. I want to search column A and return a value in
column B for each row. In col A a have text a numbers. If the text "TRIP" is found in a row and want to show a text in col B eg "trip repo". If it is not found I want to show another text eg "repo". I seems easy but I tried functions and they only return an error if the text is not found. How can I do this? please help! /i use swedish excel so i dont really know the name of the function that i tried in english). thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find in string
If your column A cell will contain only "TRIP" then try
=IF(A1="TRIP","trip repo","repo") I you are looking for any string including "TRIP", then try =IF(ISERR(FIND("TRIP",A1)),"repo","trip repo") For translations of function names between languages (including Swedish), try http://dolf.trieschnigg.nl/excel/excel.html -- David Biddulph "Arne Hegefors" wrote in message ... Hi! I have a long list. I want to search column A and return a value in column B for each row. In col A a have text a numbers. If the text "TRIP" is found in a row and want to show a text in col B eg "trip repo". If it is not found I want to show another text eg "repo". I seems easy but I tried functions and they only return an error if the text is not found. How can I do this? please help! /i use swedish excel so i dont really know the name of the function that i tried in english). thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find in string
Hi Arne
=IF(ISNUMBER(SEARCH("TRIP";A1));"trip repo";"repo") Note Search() is not case sensitive and will find TRIP, Trip and trip. If you only want TRIP, then use the case sensitive FIND() -- Regards Roger Govier "Arne Hegefors" wrote in message ... Hi! I have a long list. I want to search column A and return a value in column B for each row. In col A a have text a numbers. If the text "TRIP" is found in a row and want to show a text in col B eg "trip repo". If it is not found I want to show another text eg "repo". I seems easy but I tried functions and they only return an error if the text is not found. How can I do this? please help! /i use swedish excel so i dont really know the name of the function that i tried in english). thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Numeric sign in a string | Excel Worksheet Functions | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Hyperlinks in Excel | Excel Worksheet Functions | |||
find nth position of a string | Excel Discussion (Misc queries) | |||
Find first numeric value in text string | Excel Worksheet Functions |