concatenation of multiple cells

shodan

Active Member
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?

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
10
Views
208
Replies
14
Views
382
Replies
5
Views
216
Replies
6
Views
215
Replies
2
Views
155

1,203,515
Messages
6,055,854
Members
444,828
Latest member
StaffordStag

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back