| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to give escape sequence in Excel string literals...
Hi,
I found that Excel does not allow C-lang style escape sequence. E.g. \" like escape is not allowed. I tried with other tinkering as well but did not work. Could not found direct pointer from Excel help. Can somebody help, how to put escape sequences in Excel functions? Thanks for your time. - KA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to give escape sequence in Excel string literals...
you can use chr(34) and concatenate it. (or produce any character using chr)
In line for double quotes, you double the double quote sStr = "this is ""Jim's"" last chance" from the immediate window: sStr = "this is ""Jim's"" last chance" ? sStr this is "Jim's" last chance \n would be the constant vbNewLine "this is placed" & vbNewLine & "on two lines" but as you see, you need to use concatenation. ? "this is placed" & vbNewLine & "on two lines" this is placed on two lines -- Regards, Tom Ogilvy wrote in message oups.com... Hi, I found that Excel does not allow C-lang style escape sequence. E.g. \" like escape is not allowed. I tried with other tinkering as well but did not work. Could not found direct pointer from Excel help. Can somebody help, how to put escape sequences in Excel functions? Thanks for your time. - KA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to give escape sequence in Excel string literals...
Thanks Tom, it worked.
Thanks for your time and solution. Regards. - Kedar Agarkar Tom Ogilvy wrote: you can use chr(34) and concatenate it. (or produce any character using chr) In line for double quotes, you double the double quote sStr = "this is ""Jim's"" last chance" from the immediate window: sStr = "this is ""Jim's"" last chance" ? sStr this is "Jim's" last chance \n would be the constant vbNewLine "this is placed" & vbNewLine & "on two lines" but as you see, you need to use concatenation. ? "this is placed" & vbNewLine & "on two lines" this is placed on two lines -- Regards, Tom Ogilvy wrote in message oups.com... Hi, I found that Excel does not allow C-lang style escape sequence. E.g. \" like escape is not allowed. I tried with other tinkering as well but did not work. Could not found direct pointer from Excel help. Can somebody help, how to put escape sequences in Excel functions? Thanks for your time. - KA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to give a string of data into different columns | Excel Worksheet Functions | |||
| search a string as substring and give adjacent values | Excel Worksheet Functions | |||
| How to look for a sequence of numbers in a string? | Excel Discussion (Misc queries) | |||
| Search for a string sequence in a cell | Excel Programming | |||
| Escape for special characters in string | Excel Programming | |||
Hybrid Mode
