Translation/formula.

I

Ivan

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
 
R

RagDyer

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

Select the cells and try
<Edit> <Replace>,

In "Find What", enter:
<space>sek

In "Replace With", enter:
<space>sec

Then "Replace All"
 
T

T Kirtley

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
 
I

Ivan

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:
 
T

T Kirtley

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
 
J

JLatham

The Find and Replace function should do it for you with all existing
instances of sek.

If you're worried about people typing it into a cell later, you may want to
look at Tools | Options | [Spelling] tab | {AutoCorrect Options...} button
and enter sek in the 'Replace' entry, and sec in the 'With' entry area.
 
I

Ivan

Hi.

That just might be the thing I need. I'll try it tomorrow, when at work.
Otherwise I'll probably post a comment again ;-). Thanks so much for the help.

Ivan.

"T Kirtley" skrev:
 
Top