Formatting cells having same pattern

[maddyyikes]

Hi,
I have the following two cells on my spreadsheet with the values: "Jack", (cell 1)
Daniels (cell 2)

I am trying to get the double quotes and the comma for Daniels as well but am unable to do so for some reason. I have tried doing a paste special and the custom field properties option but it didnt seem to work. I guess I'm missing something in the process..please help.. Thanks in advance

 

[SkipVought]

Hi,

In Data/Text to Columns -- DELIMITED...

check to see that the Space and Comma delimiters are UNCHECKED.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[maddyyikes]

Hi,
Thanks for the immediate reply ...but I tried that as well, however it does not do it still.. please help..thanks in advance!

 

[Lilliabeth]

I am trying to get the double quotes and the comma

get? Please explain what you want.

with the values: "Jack",

Does the cell contain the quotation marks and comma characters, or are they just displayed via formatting?

 

[maddyyikes]

The cells contain the quotation and comma characters via formatting. Thanks for all your help once again!

 

[combo]

Try custom cell format:
\"@\"\,

combo

 

[firefytr]

Check out the Format Painter.

-----------
Regards,
Zack Barresse