I have a number of rows of data that I need to truncate, similar to the following:
PF-CSD-1881-24.8G
PF-WT-26MM-21G
PF-WT-26MM-26.2G
PF-WT-26MM-32.4G
I want the UDF to return the following:
24.8
21
26.2
32.4
Any thoughts on how best to get rid of the G at the end (easy part) and then remove up through the last hyphen? I tried combinations of left, right, mid, find, and len and couldn't get it right without using a macro but am stuck and confused. Thanks for any help you can provide!
Bookmarks