adding text to end of all cells in column

**xkatx21x** · 02-17-2010, 12:02 AM

Hi I have about 5000 rows of data and I need to add the same letters (.jpg) the the end of all the data in a column.

Is there any quick way to do this?

**mdbct** · 02-17-2010, 12:07 AM

use the following formula:
=A1 & ".jpg"
Copy down the formula down the column
Copy the column
Paste Special... Values over the original column

**JBeaucaire** · 02-17-2010, 12:08 AM

In an adjacent column, use a concatenation formula like this:

=A1 & ".jpg"

Copy that down.
Copy the new cells with the formulas
Click on the original data
Do a Edit > Paste Special > Values over the top of the old text
Delete the new column.

Done.

**xkatx21x** · 02-17-2010, 12:11 AM

Thank you, both of you.
Works perfectly.

**JBeaucaire** · 02-17-2010, 02:51 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

============
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)