Glenn Masterson
New Member
- Joined
- Feb 17, 2005
- Messages
- 49
I enter data from the internet by right clicking a cell and clicking refresh.
In one column are the prices of the players which look like this £5.5m
Can someone give me a formula that will get rig of the  and m so I am left with £5.5
Then I need it to be recognize as numbers as I need to add the results up in a different sheet.
Thank you
Glenn
In one column are the prices of the players which look like this £5.5m
Can someone give me a formula that will get rig of the  and m so I am left with £5.5
Then I need it to be recognize as numbers as I need to add the results up in a different sheet.
Thank you
Glenn