| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display double quotes in an cell
I have Fname and Lname cells and want a third cell that displays double
quotes around the full name. How do I get the quotes to show? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
=""""&A1&" "&B1&""""
-- HTH, Laura Cook Appleton, WI "rpurosky" wrote in message ... I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
="""&A1&" "&B1&"""
"rpurosky" wrote: I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
I tried yours, but it didn't work. The cell would actually display verbatim.
Laura Cook's suggestion of four quotes in a row did the trick. "Teethless mama" wrote: ="""&A1&" "&B1&""" "rpurosky" wrote: I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
One mo
=char(34) & a1 & " " & b1 & char(34) =char(34) is a double quote. rpurosky wrote: I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
=IF(A2=CHAR(32),"yes","no") through =IF(A2=CHAR(126),"yes","no") '[normal
keyboard characters] works as expected. How do I make it work with CHAR(248) '[other than normal keyboard characters]? Lou "Dave Peterson" wrote: One mo =char(34) & a1 & " " & b1 & char(34) =char(34) is a double quote. rpurosky wrote: I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display double quotes in an cell
Learned a bit since my last post "Alt"248 = °. The same character in excel is
CHAR(176). Why??? I'm so confused Lou "Rookie 1st class" wrote: =IF(A2=CHAR(32),"yes","no") through =IF(A2=CHAR(126),"yes","no") '[normal keyboard characters] works as expected. How do I make it work with CHAR(248) '[other than normal keyboard characters]? Lou "Dave Peterson" wrote: One mo =char(34) & a1 & " " & b1 & char(34) =char(34) is a double quote. rpurosky wrote: I have Fname and Lname cells and want a third cell that displays double quotes around the full name. How do I get the quotes to show? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Parse csv files | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
