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?
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?
Last edited by xkatx21x; 02-22-2010 at 09:47 PM.
use the following formula:
=A1 & ".jpg"
Copy down the formula down the column
Copy the column
Paste Special... Values over the original column
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you, both of you.
Works perfectly.
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.)
Thanks JBeaucaire, this was exactly what I was looking for
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks