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.
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.
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.
Hi John,
assuming your first one is in A2, =VALUE(LEFT(A2,LEN(A2)-4)) in row 2
of any other column could be filled down to produce a column of number
values.
I'm also assuming that it is a single space between the number and the
g.
Ken Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks