Hi.
I have a data set that can be numbers or string:
0.385
19.656
33.133
270.268
319.694
650.000
157.500
13499.460
For various reasons I only want the first 7 characters/numbers.
So the only 1 that would change in the list above is the last one, to 13499.46. I can't change the fixed decimal as there are some smaller numbers that need to be at 3 decimal places.
I'm not great when it comes to working out the Trim functions or RegEx so any help would be great.
Thanks
Solved! Go to Solution.