How do I enclose all data values in a column in double quotes?

M

ms.kitty

Need to enclose data values in double quotes in a column using a function.
Any ideas out there?
 
P

Per Jessen

Hi
If you have your data in B1 use this formula in C1

=CHAR(34) & B1 & CHAR(34)

You can hide column B if you don't want it shown.

Regards,

Per
 
T

tim m

I would think the best way would be to do a custom format for the cells
however if it has to be a function...
This is an incredibly cheesy way of doing it and undoubtably not the best
solution but it seems to work.

I put " in cell B1 I then used this formula:

=$B$1&A1&$B$1 and copied it down (assuming data starts in A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
MS Project Center-Autolink column fields 0
Calculate the median value before a specified list 0
Line Feed in Formula Adds Double Quotes? 3
How to center adjust text above and image in a two column document. 1
Transfertext enclose number fields in quotes 6
Help, how do I import a CSV file when Negatives are in Parenthesis 3
How to have two tables on same line? 1

Top