| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Text Function (Right, Left)
My sheet has columns like this
A 1. 63mmx 4kg 2. 75mmx 4kg SWR How can i detect that if a1:a2 is right,3 "swr", that it should be returned 3 otherwise 6. How can i add =right function with conditional formula. Help me Rao Ratan singh |
|
#2
|
|||
|
|||
|
Hi
=IF(RIGHT(A1,"SWR"),3,6) fill down your column (move cursor over bottom right hand corner of the cell when you see a +, double click) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Rao Ratan Singh" wrote in message ... My sheet has columns like this A 1. 63mmx 4kg 2. 75mmx 4kg SWR How can i detect that if a1:a2 is right,3 "swr", that it should be returned 3 otherwise 6. How can i add =right function with conditional formula. Help me Rao Ratan singh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
Linear Mode
