List Maker with comma between

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

List Maker with comma between

Post by 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.
You do not have the required permissions to view the files attached to this post.

User avatar
StuartR
Administrator
Posts: 12706
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: List Maker with comma between

Post by StuartR »

You need to replace each ' in your formula with two consecutive " characters, see the formulae in this version:
You do not have the required permissions to view the files attached to this post.
StuartR


matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Re: List Maker with comma between

Post by matthewR »

Thank you - that works.