Formatting a column 1

[runnerlk]

I need to format a column and add "" around each value in the cloumn. I am thinking there must be some formula that would do this. Any help would be greatly appreciated

 

[AnotherHiggins]

-> I am thinking there must be some formula that would do this.

You probably noticed that
=""" & A1 & """ returns " & A1 & ".

That's because Excel thinks the outer quotes are telling it that everything inside them is text. You want to tell Excel the actually display double quotes.

To do that, you just add another quote in there, so you wind up with a pair of double quotes around a pair of double quotes. It looks like this:
[tab][COLOR=blue white]="""" & A1 & """"[/color]

Fill the formula down, Copy, Paste Special > Values in the original column. Then delete the helper column.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[runnerlk]

Thanks John, I was not using enough ".