single quote/CID/single quote/comma

Are you OK with using a VBA function to do this?

If so, copy the code at this link:

http://www.excelforum.com/showthread...=1#post3096647

Paste it into a general module.

Then, use it on the worksheet like this:

Data Range

	A	B
1
2	728474	('728474','1002208755','1001873448','783715','791490')
3	1002208755
4	1001873448
5	783715
6	791490

This array formula** entered in B2:

="("&concatall("'"&A2:A6&"'",",")&")"

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Try this
=123456 & CHAR(10) & 235698 & CHAR(10) & 34567
Format the cell to wrap text, right click the cell=>select format cells select the Alignment tab and check Wrap Text

Did you put the VBA code in the right place?

OK, we're making progress!

To account for empty cells:

Data Range

	A	B
1
2	728474	('728474','1002208755','1001873448','783715','791490')
3	1002208755
4	1001873448
5	783715
6
7
8	791490
9
10

This array formula** entered in B2:

="("&concatall(IF(A2:A10<>"","'"&A2:A10&"'",""),",")&")"

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.