concatenation of multiple cells

[shodan]

hi all,

Often I need numbers formatted like this:

'300','200','100',


the workarround I use is as follows:

Book1
	B	C	D	E	F
9		100	'100',	'100',
10		200	'200',	'200','100',
11		300	'300',	'300','200','100',
12
13	Copied as values only			'300','200','100',
14
Sheet1

where after the last concatenation i copy/paste values to get the desired result. I was wondering, can this be done with one formula/step?

 

[PaddyD]

download the morefunc addin (see the recommended addins & links thread at the top of the board) & use mconcat()