Assuming you want the same text prepended and appended to each of the
500 cells, you could insert a blank column next to D. In a blank
section of your sheet (columns U and V?) enter your prepend values in
one cell (U1) and append values in another (V1).
In your new, blank E1, enter this formula:
=$U$1&D1&$V$1
copy this down 500 rows.
Now, copy column E, Paste Special Values over top of itself and then
Delete Column D
Good Luck
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=477207