I'm not sure that I understand, but if you mean that you want to specify what
text to change in cells m3 and n3 you can modify the formula to refer to the
cells with the old and new text values. Something like:

=SUBSTITUTE(A3,m3,n3)

would have the same effect on the text in cell A3 if the values in M3 and N3
are " sek" and " sec"

Is that what you need?

TK

"Ivan" wrote:

Hi TK,

Thanks for the quick answer, in some instances I think it will do the trick.
In some situations, however, the "sek" and the "sec" will be placed in two
blocks (for instance m3 and n3), so I also need a code that (with the
sentence in hand) always changes m3 to n3 (i.e. "sek" to "sec"). Is that
possible (I'm kinda new at this excel-thing ;-))?

Best regards, Ivan.


"T Kirtley" skrev:

Hi Ivan,

You can do a Find/Replace operation to change all occurances of " sek" to "
sec" (the leading space is intentional) or if you don't want to alter the
initial data you can use a formula such as:
=SUBSTITUTE(A1," sek"," sec") presuming that the initial value is in cell A1.

HTH,

TK

"Ivan" wrote:

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