List Maker with comma between

[matthewR]

I have this list maker excel sheet. What it does is, you put a list of numbers in column A. The concatenate calculation is in column B. Once you get the numbers in column A, you copy the formula down in column B and it puts single quotes around the number and a comma between the numbers. My problem is how do you change the formula to put double quotes around the number instead of single quotes.

Once you copy down the calculation, you highlight the last number in column B and do a copy, paste special values and then you have a list of text numbers (maybe like zip codes) that you can use in an "In statement" in an Access query so you don't have to type the numbers with quotes around them if you have say 50 numbers or more. You can use this for any text value that needs comma between and quotes around.

[StuartR]

You need to replace each ' in your formula with two consecutive " characters, see the formulae in this version:

[matthewR]

Thank you - that works.