Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 260
Default chr() for quotation mark

Hey guys

What is the chr code for quotation marks?


Thanks
Todd
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default chr() for quotation mark

? asc("""")
34

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
Hey guys

What is the chr code for quotation marks?


Thanks
Todd



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default chr() for quotation mark

To find the code for a character:

Sub FindCode()
MsgBox Asc(InputBox("What character?", "Find Code"))
End Sub


Todd Huttenstine wrote:
What is the chr code for quotation marks?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default chr() for quotation mark

?asc("""") in the immediate window gives it to you

--
HTH

-------

Bob Phillips
"Don Lloyd" wrote in message
...
34

"Todd Huttenstine" wrote in message
...
Hey guys

What is the chr code for quotation marks?


Thanks
Todd





  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default chr() for quotation mark

34

"Todd Huttenstine" wrote in message
...
Hey guys

What is the chr code for quotation marks?


Thanks
Todd





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default chr() for quotation mark

one other fast way is to take a look in the help (VBA)
character or characters
there's in the help a list of all the codes
(a first 0-128 and a last one up to 256)


  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default chr() for quotation mark

on my computer its 63 ... perhaps because I'm in UK

"Todd Huttenstine" wrote in message
...
Hey guys

What is the chr code for quotation marks?


Thanks
Todd



  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default chr() for quotation mark

Hi sa3214,

I think you confuse the question mark (?) with the discussed quotes ("").

Incidentally, your location is not a relevant consideration. In this this
connection, you might look at Bob's signature line used indicate very
explicitly his UK status..


---
Regards,
Norman



"sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message
...
on my computer its 63 ... perhaps because I'm in UK




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Single Quotation mark in CSV hon123456 Excel Discussion (Misc queries) 1 November 29th 08 07:49 AM
Single Quotation mark in CSV hon123456 Excel Discussion (Misc queries) 0 November 29th 08 05:15 AM
how to put quotation mark in each cell of the column crazyfisher Excel Worksheet Functions 17 October 16th 08 08:44 PM
Single or Double Quotation Mark and it comes up twice J.R.HOLMES Setting up and Configuration of Excel 1 December 31st 05 08:51 PM
how do I concatenate text that has a quotation mark sparkroms Excel Discussion (Misc queries) 2 July 8th 05 09:20 PM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"