software

I have something like this quot;5314RY89quot; entered in the first row in column B.
It will not be the same number in every cell. There are about 250 rows so
far. I need to add quot;WONOquot; at the beginning of each entry so it will show
quot;WONO5314RY89quot;

How can I replicate/add the WONO without doing each cell individually.

One way, in say, C1, copied down:
=IF(TRIM(B1)=quot;quot;,quot;quot;,quot;WONOquot;amp;TRIM(B1))
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;roy.okinawaquot; gt; wrote in message
news
gt; I have something like this quot;5314RY89quot; entered in the first row in column
B.
gt; It will not be the same number in every cell. There are about 250 rows so
gt; far. I need to add quot;WONOquot; at the beginning of each entry so it will show
gt; quot;WONO5314RY89quot;
gt;
gt; How can I replicate/add the WONO without doing each cell individually.
I might be doing something wrong. I keep getting a circular reference when
try the formula.

Here is an example of what I have. I want to put WONO in front of the rest
w/o having to type it in one at at time:

B
WONO5314RY89
5323RY90
5214RY64
5300RY67quot;Maxquot; wrote:

gt; One way, in say, C1, copied down:
gt; =IF(TRIM(B1)=quot;quot;,quot;quot;,quot;WONOquot;amp;TRIM(B1))
gt; --
gt; Rgds
gt; Max
gt; xl 97
gt; ---
gt; Singapore, GMT 8
gt; xdemechanik
gt; savefile.com/projects/236895
gt; --
gt; quot;roy.okinawaquot; gt; wrote in message
gt; news
gt; gt; I have something like this quot;5314RY89quot; entered in the first row in column
gt; B.
gt; gt; It will not be the same number in every cell. There are about 250 rows so
gt; gt; far. I need to add quot;WONOquot; at the beginning of each entry so it will show
gt; gt; quot;WONO5314RY89quot;
gt; gt;
gt; gt; How can I replicate/add the WONO without doing each cell individually.
gt;
gt;
gt;

As mentioned (the source data assumed in B1 down), put the formula in an
adjacent cell, say C1, then copy down. Then copy col C and do a paste
special gt; values to overwrite col B. Then delete/clear col C.
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;roy.okinawaquot; gt; wrote in message
...
gt; I might be doing something wrong.
gt; I keep getting a circular reference when try the formula.
gt;
gt; Here is an example of what I have. I want to put WONO in front of the
rest w/o having to type it in one at at time:
gt;
gt; B
gt; WONO5314RY89
gt; 5323RY90
gt; 5214RY64
gt; 5300RY67
Thanks.

quot;Maxquot; wrote:

gt; As mentioned (the source data assumed in B1 down), put the formula in an
gt; adjacent cell, say C1, then copy down. Then copy col C and do a paste
gt; special gt; values to overwrite col B. Then delete/clear col C.
gt; --
gt; Rgds
gt; Max
gt; xl 97
gt; ---
gt; Singapore, GMT 8
gt; xdemechanik
gt; savefile.com/projects/236895
gt; --
gt; quot;roy.okinawaquot; gt; wrote in message
gt; ...
gt; gt; I might be doing something wrong.
gt; gt; I keep getting a circular reference when try the formula.
gt; gt;
gt; gt; Here is an example of what I have. I want to put WONO in front of the
gt; rest w/o having to type it in one at at time:
gt; gt;
gt; gt; B
gt; gt; WONO5314RY89
gt; gt; 5323RY90
gt; gt; 5214RY64
gt; gt; 5300RY67
gt;
gt;
gt;

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;roy.okinawaquot; gt; wrote in message
...
gt; Thanks.