markdd Posted April 16, 2020 Share Posted April 16, 2020 Currently, weight values for Lighting devices are reported to worksheets using the measurement and the Unit (ie 42 kg). This means that the SUM function will not work. Is there a way of stripping out the "kg" or "lbs" value to just see the number, or is there a function that I should be using that ignores the Unit suffix? Any help would be really helpful. Many thanks Mark Quote Link to comment
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.