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

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

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