Quote:
Originally Posted by GMScott
That's a great question... to which I do not know the answer. I'm using Excel's Power Query. More like learning it. I can't seem to figure out how to get it to ignore everything past the period.
Does anyone have any suggestions?
|
I'm not familiar with it, but there's probably something somewhere to split on a delimiter, in which case you could split on the period and just discard the number value.