View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ivan ivan is offline
external usenet poster
 
Posts: 67
Default Translation/formula.

Hey.
I'm having some trouble with my excel. I have lines such as this:

4Nm 24V AC/DC 2/3 PKT. IP55 90 sek

I need to change the "sek" into "sec" so that it is the only element in the
sentence being changed (i.e. if I later on copy-paste, the "sek" will always
be changed into "sec", while the remainder of the sentence may or may not
change). Is there a formula that will do this?

Best regards, Ivan