Cell Formatting HELP Please

S

Steve_1_B

I have a cell from one of my venders that sorts there products jpg's
with excel but i need to add something to the end of the id's the
problem i'm having is how to do it the id's are all different the all
start with text and then numbers but some have text,text,## othere are
different here are some of them.
What i would like to add to the end of them is _BM how do i do it??
Thanks for the help
Steve

D1125
LF70
D369
PF339
PF125
MF94
MF104
G384
G385
LF66
MF132
MF128
M618
M617
M634
M633
M619
M620
M725
M733
PF2
PF5
PF3
PF4
PF6
PF1
MF95
M563
 
S

Steve_1_B

That works but it will not work for me because the A1 column need to be
the one that get formatted this way and if you try to copy and past
column B into column A it looses the formatting??
Steve
 
0

0-0 Wai Wai ^-^

Max said:
One way ..

Assuming the data is in col A, in A1 down

Put in B1: =TRIM(A1)&"_BM"
Copy B1 down
Col B will return what's desired

If required, freeze the values in col B
with an in-place > copy > paste special > check "values" > ok
Click to expand...

If I understand correctly, it seems the questioner wishes to add _BM to the IDs.
If it is so, you don't need to use the TRIM function.

Try this simpler method instead.
Assuming the IDs is in col A1 - A100

1) Put this formula in B1:
=A1&"_BM"

2) Apply the formula in B1 to B2-B100. To do so:
- Highlight B1
- Can you see the small black square on the bottomright? Hold this square
- drag around until you reach B100

3) Then copy the values in col B to col A.
If you wish to keep all the formattings etc. in col A, you should use special
paste. To do so:
- right-click mouse | select "paste special" | check/select "values" | click
"ok"
 
0

0-0 Wai Wai ^-^

Oh I see.
Originally the IDs seem to contain no spacing (if it does have spacing, the
author may wish to keep the exact spacing), saving this formula will be easier
to understand (for newbies) & save a bit of processing time (although very
negligible).
That's what I think originally.
 
Top