markdd Posted October 25, 2024 Share Posted October 25, 2024 Does anyone know of a worksheet function that will take a Text string, say: "15 kg" and report just "15" as a numeric value? I have searched this page https://developer.vectorworks.net/index.php?title=Worksheet_Functions but have drawn a blank. Thanks. Quote Link to comment
Tom W. Posted October 25, 2024 Share Posted October 25, 2024 Could you use SUBSTRING to return the first substring then VALUE to convert it into a number...? 2 Quote Link to comment
markdd Posted October 25, 2024 Author Share Posted October 25, 2024 I never thought of using a space as a delimiter! Perfect. Thanks Quote Link to comment
Recommended Posts
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.