CONCATENATE

[Bedford]

Trying to combine contents of 2 cells, A1 contains; Monarch Glide, Recess Mount, W=500mm (19 11/16"), H=900mm (35 7/16"), B1 contains; Single Slide, I'm trying to move contents of B1 to a specific location, resembling; Monarch Glide, Recess Mount, Single Slide, W=500mm (19 11/16"), H=900mm (35 7/16").
Anyone have any thoughts?

Thank you.

 

[mrshl9898]

Is the second comma always the indicator?

=LEFT(A1,FIND(CHAR(160),SUBSTITUTE(A1,",",CHAR(160),2))+1)&B1&MID(A1,FIND(CHAR(160),SUBSTITUTE(A1,",",CHAR(160),2)),LEN(A1))

 

[Saurabhj]

Hi Bedford,

I hope there will be more rows which would be helpful to check the pattern.

Meanwhile check below if it works.

=CONCATENATE(MID(A1,1,FIND(",",A1,FIND(",",A1)+1)),B1,", ",MID(A1,FIND("W=",A1),99))

Saurabh

 

[Bedford]

=LEFT(A1,FIND(CHAR(160),SUBSTITUTE(A1,",",CHAR(160),2))+1)&B1&MID(A1,FIND(CHAR(160),SUBSTITUTE(A1,",",CHAR(160),2)),LEN(A1))

The second comma is not an indicator for this exercise, so I removed it and the result was great. Thanks loads.

 

[Bedford]

=CONCATENATE(MID(A1,1,FIND(",",A1,FIND(",",A1)+1)),B1,", ",MID(A1,FIND("W=",A1),99))

Hi Saurabh, this one worked as well, only there was no space before the insertion of B1, any thoughts on a workaround for that?
Thank you,

 

[Saurabhj]

Hi,

Small change to add space:

=CONCATENATE(MID(A1,1,FIND(",",A1,FIND(",",A1)+1)),CHAR(32),B1,", ",MID(A1,FIND("W=",A1),99))

Saurabh