concatenation of multiple cells

shodan

Active Member
Joined
Jul 6, 2005
Messages
481
hi all,

Often I need numbers formatted like this:

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


the workarround I use is as follows:
Book1
BCDEF
9100'100','100',
10200'200','200','100',
11300'300','300','200','100',
12
13Copied 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?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
download the morefunc addin (see the recommended addins & links thread at the top of the board) & use mconcat()
 

Watch MrExcel Video

Forum statistics

Threads
1,118,291
Messages
5,571,334
Members
412,382
Latest member
Langtn02
Top