jmckeone
Well-known Member
- Joined
- Jun 3, 2006
- Messages
- 550
I work with bandwidth which is normally in raw number format. This week someone sent me a massive spreadsheet with information in text format similar to the following examples:
204.36k (item in kilobits)
202.56M (item in megabytes)
1.257G (item in gigabytes)
My aim is to standardize cell contents as a number in megabytes. I would like to be able to do is write code that will look in a range, lets say AU2:DV1500, and whenever it finds in a cell(items aren't case sensitive):
k - remove the k and multiply cell contents by .001
m - remove the m
G - remove the G and multiply cell contents by 1000
Appreciate any assistance that can be provided on this.
204.36k (item in kilobits)
202.56M (item in megabytes)
1.257G (item in gigabytes)
My aim is to standardize cell contents as a number in megabytes. I would like to be able to do is write code that will look in a range, lets say AU2:DV1500, and whenever it finds in a cell(items aren't case sensitive):
k - remove the k and multiply cell contents by .001
m - remove the m
G - remove the G and multiply cell contents by 1000
Appreciate any assistance that can be provided on this.