Jump to content

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

Link to comment

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.

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.

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.

  • Create New...