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

If I understand your question correctly the following should work:

in column B

=IF(RIGHT(A1,3)="SWR",3,6)

Copy this down column B and it should return 3 wherever Column A ends SWR

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" <[email protected]> wrote in message
news:[email protected]...
> 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