View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Translation/formula.

Is there always a <space before the "sek"?

Select the cells and try
<Edit <Replace,

In "Find What", enter:
<spacesek

In "Replace With", enter:
<spacesec

Then "Replace All"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ivan" wrote in message
...
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