I have an excel document with 5000 items listed in it.  I have a
column called Image that contains the image names for all of the
items.  Right now it contains our product codes, for example row 1
would be picture1 , row 2 would be picture2

I need to know if there is a way for me to add an extension to each
word, for example of the above words, i would want them to be
picture1.jpg , picture2.jpg

Is there a way to automate this, or anything easier than going through
each row and adding .jpg to each word?

---

Request for Question Clarification by googlenut-ga on 02 Jan 2004 14:22 PST

RFC:

Hello sgwilton-ga,

I find it difficult to explain to someone how to do something in Excel
without looking over their shoulder while they do it.  But since I
can?t look over your shoulder, I?ll try explaining it here. If this
works for you, let me know and I?ll post it as the official answer to
the question.

Also, you may want to copy your original file to a temporary file
before you try this.  That way, if it doesn?t work, you won?t ruin
your original file.

+++++++++++++++++++++++++++

- Let?s assume that your column called ?Image? is in column A and row
1 is the title row. This would mean that the title of column A,
"Image" is in cell A1.

- Insert 2 columns after your image column (you now have two blank columns, B & C)

- Type ".jpg" (without the quotes) in cell B2 (the cell next to the
first cell in your list of images, (i.e. in the cell to the right of
picture1))

- Highlight all the cells in that column starting with cell B2 (the
cell you typed ?.jpg? in) through the cell next to the last entry in
your image list. Then type ?control d? (hold down the "Ctrl" key and
type d).  This should fill down ?.jpg? in that column.

- In the first cell in the second empty column (C2), enter the
equation "=A2&B2" (without the quotes). Once again, this assumes that
your list is in column A.  If it isn?t, replace ?A2? and ?B2? in the
equation with the correct cell ID?s.

- Fill this equation down in column C the same way that you did in
column B (highlight cell C2 through the last cell in that column that
corresponds to an entry in column A, then ?control d?).

- Column C should now contain the names with .jpg attached.

- Highlight the cells in column C from C2 though the end of the list.
Copy these cells.  Then do a "paste special values" into the
corresponding cells in column A.

- Column A should now contain the names with the .jpg extension attached.

- Delete columns B & C.

+++++++++++++++++++++++++++

Let me know if this works or if there is anything about my explanation
that you don?t understand.

Googlenut

---

Clarification of Question by sgwilton-ga on 02 Jan 2004 15:37 PST

Googlenut,

You saved the day!  This works perfectly!

I have another question regarding excel that I will post later this evening. 

Appreciate your help.

Hello sgwilton-ga,

I?m glad I was able to help you out.  I?ll repeat the information from
my request for clarification here to make the answer complete.

Googlenut

+++++++++++++++++++++++++++

- Let?s assume that your column called ?Image? is in column A and row
1 is the title row. This would mean that the title of column A,
"Image" is in cell A1.

- Insert 2 columns after your image column (you now have two blank columns, B & C)

- Type ".jpg" (without the quotes) in cell B2 (the cell next to the
first cell in your list of images, (i.e. in the cell to the right of
picture1))

- Highlight all the cells in that column starting with cell B2 (the
cell you typed ?.jpg? in) through the cell next to the last entry in
your image list. Then type ?control d? (hold down the "Ctrl" key and
type d).  This should fill down ?.jpg? in that column.

- In the first cell in the second empty column (C2), enter the
equation "=A2&B2" (without the quotes). Once again, this assumes that
your list is in column A.  If it isn?t, replace ?A2? and ?B2? in the
equation with the correct cell ID?s.

- Fill this equation down in column C the same way that you did in
column B (highlight cell C2 through the last cell in that column that
corresponds to an entry in column A, then ?control d?).

- Column C should now contain the names with .jpg attached.

- Highlight the cells in column C from C2 though the end of the list.
Copy these cells.  Then do a "paste special values" into the
corresponding cells in column A.

- Column A should now contain the names with the .jpg extension attached.

- Delete columns B & C.

+++++++++++++++++++++++++++

Search Strategy:

None. I Used personal knowledge of Excel.