Worksheet functions

[The Hamma]

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

[Pat Stanford]

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.

[The Hamma]

Thanks, 

Edited May 16, 2020 by The Hamma