Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL formula

Status
Not open for further replies.
wuwang

wuwang

Programmer
May 16, 2001
48
US
Hi,


I like to put a formula in character column and the output
should be with single quote (e.g. 'here is output').
I was told to use formula in edit formula like
= """"&D2&""""
but the output is double quote "here is output".

Could you help me with this problem?

Thanks

Laura
 
Sort by date Sort by votes

=+CHAR(39)&"Here is quote"&CHAR(39)
or
=+CHAR(39)&D2&CHAR(39)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
309
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
177
TomSalvato
TomSalvato
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
301
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
297
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
885
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top