Jump to content

Worksheet - Reading character from function in cell

Recommended Posts

I use object names often when I want to do a worksheet of areas, with each names object having a corresponding name in the worksheet to identify it.


Is there a way that I can parse/read an object Name (e.g. D [  =AREA(N='D')  ]  in in D5 in image encl) and have another cell read and show/display/print that name? It sure would save a lot of double entry and avoid errors. I do not see a function enabling reading (in vw 2012) characters.

Getting text string from function in cell.JPG

Link to comment

I think you want to read up on Worksheet Database Rows. It is perfect for what you are doing where you are repeating the same formulas over and over.


=N is the formula to display the object name in a worksheet cell. If you use it in a Database row you would use it just as written.


In a Spreadsheet cell you would need to use a criteria with it.  =N(L='Layer 1')

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...