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

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

Translation/formula.
 

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

Translation/formula.
 

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

Translation/formula.
 

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

Translation/formula.
 

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.

"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

Translation/formula.
 

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:

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