| View Question |
|
|
 | ||
|
| Subject:
How do you pring the quote character in excel
Category: Computers Asked by: stevenclary-ga List Price: $2.00 |
Posted:
14 Apr 2004 06:33 PDT
Expires: 14 Apr 2004 10:25 PDT Question ID: 330050 |
How do you pring the quote character in excel (Without excel interpreting it as a command charater). I have tried to do this: =B1&C1&""Phrase in quotes"" (Without success) I even tried using /n before the ". |
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: How do you pring the quote character in excel
From: probonopublico-ga on 14 Apr 2004 06:36 PDT |
You use it twice! |
| Subject:
Re: How do you pring the quote character in excel
From: probonopublico-ga on 14 Apr 2004 06:39 PDT |
I always use the ' character, which needs to be entered twice. If I use the " character, it only needs to be entered once. Which version of Excel are you using? |
| Subject:
Re: How do you pring the quote character in excel
From: stevenclary-ga on 14 Apr 2004 07:24 PDT |
Evcel version 2003 |
| Subject:
Re: How do you pring the quote character in excel
From: probonopublico-ga on 14 Apr 2004 09:49 PDT |
Aha ... I use Excel 2000. Maybe it's a bug? |
| Subject:
Re: How do you pring the quote character in excel
From: dewmeht-ga on 14 Apr 2004 09:56 PDT |
For getting the double quote character in any formula in excel you have to show each occurrence of the double quote as "" , i.e you have to repeat it twice. So now your formula will have to be rewritten as: =B1&C1&"""Phrase in quotes""" |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |