View Single Post
  #1   Report Post  
Rao Ratan Singh
 
Posts: n/a
Default 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