How do I escape brackets?

Hi dflak,

I'd prefer to see a workbook attached to the post so I can open it and see what you have done, within the sheet and its formula. You can attach a workbook by clicking on "Go Advanced" and then the Paper Clip Icon above the advanced message area.

Believe me, I am in the choir of "show me the spreadsheet" in most cases. But sometimes the question and answer are simple.

I've been attaching both spreadsheets and text files containing the code. However it's a lot of overkill when a one line formula answers the question.

How can I express checking to see if a cell has a date earlier than today?

Please Login or Register  to view this content.

That doesn't copy and paste very well as a formula.

Or a for a table

Please Login or Register  to view this content.

Now that's easy to read.

I think including the whole spreadsheet is like parking the mail truck in your mailbox so you can get a single letter.

I find it incredulous that I'm the first person with this issue on the web site. If the answer is "live with it," that's OK, but if there is a work-around, I'd like to know about it.

Hi dflak,

Here is a formula that is from a simple table:

Please Login or Register  to view this content.

If I select the line and then click on the "#" icon above the message area it puts code tags around it and it displays in a "code" box. Is this what you are looking for?

Let me try it.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I've had screwed up code tags in the past. Don't know why it works now and not last week.

Hi,

If that is the answer you've been looking for, you could edit your original post and change the prefix to "Solved".

I have reported this problem with the brackets to the tech team, not sure if they are working over the holidays though

Hi

Just a couple of Tips that may be of some relevance here:


_1) You can experiment*** a bit with the different available Code Windows ( There are three, the one usually used then a php and a html window. Sometimes you can get away with using the various brackets in a code without the Forum Software messing things up by trying a different window. For example, JBeaucaire managed to post a code here which was full of squre brackets and Code lines containing full BB Code strings: ( He used the php code window )
http://www.excelforum.com/tips-and-t...um-thread.html
_... when I tried the same code in a normal code window it messed up.
http://www.excelforum.com/the-water-...ml#post4110530



_ But then I tried the php Window experiment in another forum, with the same code, and it messed up in a different way:
http://www.forumexcel.it/forum/16-te...ce-bb#post1549
_.. so you have to experiment a bit.

_2) There is a pair of BB Code Tags that disable the BB Code so that you can post a full BB Code which then looks exactly as you write it: They are ( Written as normal in square brackets):

NOPARSE

/NOPARSE

_.......................................................

For examples:

Please Login or Register  to view this content.

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]

_ …………………………………………………………………………………………
Then for fun I put the above two inside

Normal Code Tags

Please Login or Register  to view this content.

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE][/CODE]

_..............................................................................


html Code Tags

HTML Code: 

_...........................................................................


php Code Tags

PHP Code: 

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]

[NOPARSE][CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE][/NOPARSE] 


(_.......... *** You can experiment here: ( Note you must be logged in to see this Sub Forum )
http://www.excelforum.com/development-testing-forum/
_..………)

Alan