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
|