Appending to a field

[ryno200sx]

Hi-I have 2 quick questions:
-How do you add a .jpg extension to every record in a column? (Column
has all numbers. I need to have a .jpg extension added to every recor
in the column. i.e. Field contains 123456. I want it to sa
123456.jpg).

-My second question is similiar:
-How do I add the words "Gift Set" to the end of every record in
column? (I have a column with an product name. I want the words "Gif
Set" added to the end of the product name. i.e.-column field contain
the word Excel. I want it to say Excel Gift Set)

Any help would be greatly appreciated.
Thanks,
RT
:

 

[Peo Sjoblom]

=B1&".jpg"

where B1 holds 123456

copy down and when finished copy the lot, then
do edit>paste special as values in place

do the same for the other field

=C1&"Gift Set"

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

I would use other columns, formulas, then copy/paste special values to remove
the formulas and then delete the original columns.

For example,

A1 has 123456, A2 has 3456789, etc. in B1 I would put =A1&".jpg" and drag
that down so B2 would be =A2&".jpg", etc. I would then highlight column B, go
to Edit->Copy, then Edit->Paste Special, select Values and click OK. This
will remove the underlying formulas and I can now cut column B and paste it
over column A or just delete column A.

I'd do the same for the other question (i.e. =A1&" Gift Set").

Please let us know if you have any problems.

Hope this helps,
Nick