| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement query
In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i want to return the value "Existing". Is there a function i can use to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement query
Try this:
IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing") Hope this helps. Pete On Apr 20, 9:38 am, Rajula wrote: In a column i have some values starting with "TBA, AAA, BBB 123" . If the string begins with TBA, then i want to return TBA in another cell. else i want to return the value "Existing". Is there a function i can use to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement query
Thankyou very much, exactly what i was looking for.
"Pete_UK" wrote: Try this: IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing") Hope this helps. Pete On Apr 20, 9:38 am, Rajula wrote: In a column i have some values starting with "TBA, AAA, BBB 123" . If the string begins with TBA, then i want to return TBA in another cell. else i want to return the value "Existing". Is there a function i can use to do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement query
Glad it worked for you - thanks for feeding back.
Pete On Apr 20, 10:36 am, Rajula wrote: Thankyou very much, exactly what i was looking for. "Pete_UK" wrote: Try this: IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing") Hope this helps. Pete On Apr 20, 9:38 am, Rajula wrote: In a column i have some values starting with "TBA, AAA, BBB 123" . If the string begins with TBA, then i want to return TBA in another cell. else i want to return the value "Existing". Is there a function i can use to do this?- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement query | Excel Discussion (Misc queries) | |||
| IF statement query | Excel Worksheet Functions | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
