Wrap-text Format Question

[Drich8447]

Hello,

I have a worksheet that contains a parent product in column A, a Catagory in column B, and part numbers in column C, and again in column D. The goal is to combine all part numbers in column C and D.

Normally I would find and replace all " " with "," followed by a =CONCATENATE(C2,",",D2) formula to combine all into one cell. However, column C is formatted in a strange way that seems as though each of the numbers are separate, however, you will notice that the cell currently has wrap-text applied, when removing it the "individual" numbers appear to combine together.

Can anyone point me in the right direction as to what is occurring in column C and how I can fix it to accomplish my goal?

worksheetex.xlsx
	A	B	C	D
1	CALIBRATION	type	ON	NN
2	2007 2008 2009 VB CR4 D1 - RAM 3500 PICKUP VA - SPRINTER VB - SPRINTER	ECM	0014489240 0024468640 0064468240 0064488540 0084488640 0104483840	104486240
3	2011 P3 2.0L CVT BUX ROW P3 - CALIBER (CKD)	PCM	05150542AE	04494025AB
4	98 LH EATXIIIA WITHOUT AUTOSTICK LH - INTREPID/CONCORDE/300M	TCM	04606081AA 04606081AB 04606081AC 04606081AD 04606081AE 04606081AF 04606081AG 04606081AH 04606081AI 04606081AJ	04606081AK
Sheet1

 

[jasonb75]

Normally I would find and replace all " " with ","

Delete the space from the 'Find' box, then press Ctrl j and replace all with commas. Note that Ctrl j inserts an invisible line feed character into the box so it will look empty.