Hi all, new to excel and slowly learning..

Anyway, i have a file with about 13000 rows, and in one text field i need to remove all instances of the character ...

'

(thats an upper apostrophe)

I've tried the find/replace but it keeps coming back with 'formula too long'


Any help would be appreciated.

Also, whilst i'm on :D i need to add a .jpg to a number field

eg.. its currently '12564' and i need it as '12564.jpg' ?

Any help would be great ..

cheers
adi