View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
c8tz c8tz is offline
external usenet poster
 
Posts: 7
Default Find one character or another and display


text string: xxx-23xz-34L or can be xxx-23exv-24R0

using the formula below, how do I put it such that if it finds an R
than it puts R else if L then it puts L.

IF((MID(G6,FIND("R",G6,1),1))="R","R","L")

trying the OR function but getting confused.

and the FIND({"R","L"}.... doesn't seem to work right.

Thanks for your help