Thread: Can I create an If Statement that will replace text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default Can I create an If Statement that will replace text
glad it helped


--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
It worked! Thanks so much Bob and Don for your help.

"Don Guillett" wrote:

try putting quotes around the text

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is
not
working. Any helps or tips would be appreciated.





Reply With QuoteReply With Quote