Ben Wingrove Posted December 1, 2017 Share Posted December 1, 2017 I am trying to add some info together in a cell of a worksheet and I want it to appear as such " LED Wall @ 12' x 32' " I can do the last apostrophe by using the trailing function in the cell dialog but when I try putting the apostrophe as the foot symbol actually in the header it is obviously not letting me as that is the syntax to display a character. how can I get around this? This is what I have to make it work but I want to add the apostrophe's in to this! =CONCAT('LED Wall @ ', ('VS4-LED'.'ArrayWdth'), ' x ', ('VS4-LED'.'ArrayHght')) Thanks B Quote Link to comment
Pat Stanford Posted December 1, 2017 Share Posted December 1, 2017 You can use double and triple apostrophes to "Escape" the apostrophe you want, but I find that really hard to read and see what I have done. I prefer to use CHR(39) BUT while both of these work in scripts, neither seems to work in a worksheet formula. :-( Alternatively, put in two dummy cells (hidden if needed) that are formatted as Dimensions and just use the cell reference in the concat. NOPE, that does not work either, the value is returned as decimal feet. Easiest solution is to fall back to ft and in formatting instead of quotes. Or I might someday find the time to write you a worksheet script that will do this with proper formatting. Sorry 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.