The Hamma Posted May 15, 2020 Share Posted May 15, 2020 Is there an equivalent way to achieve this in vectoworks worksheets? I would like to just display the finish material code and not the material in the finish schedule. In excel I would create a blank column to the right column C and add this formula =LEFT(C5,FIND("]",C5)+1) See attached image Quote Link to comment
Pat Stanford Posted May 15, 2020 Share Posted May 15, 2020 Try =Substring(C5, ' ', 1) Worksheets don't have Left and Right string functions. If you can't do it with a delimiter, in this case a space character (single quote, space, single quote) you can't do it in a worksheet in 2020. The final 1 specifies which substring you want. In this was the first. Quote Link to comment
The Hamma Posted May 16, 2020 Author Share Posted May 16, 2020 (edited) Thanks, Edited May 16, 2020 by The Hamma 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.