Excel Text Function (Right, Left)

[Rao Ratan Singh]

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

 

[JulieD]

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)