Jump to content
The Hamma

Worksheet functions

Recommended Posts

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

Annotation 2020-05-15 173331.jpg

Share this post

Link to post

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.

Share this post

Link to post

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

  • Create New...