You could try find and replace. Start by selecting your data then go to
Edit/Replace:

find what: gbp
replace with: ...leave blank
hit Replace All

HTH
JG

"John" wrote:

I have cut and paste a lot of data from a web site, but it all has 'gbp'
after each amount i.e. 17.00 gbp. I need to get rid of the gbp so I can do a
SUM calculation. I hope someone can help.