I tried to simulate your case, and i dont get any error for a
find/replace. I copied your e.g. in 13000+ rows for this.
As for your second query, i.e. adding .jpg, in another column just
enter this formula:
=A1 & ".jpg"
where A1 is the number column to which you want to add .jpg, and then
copy paste-special-values to the original column.
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=373450