hello. i am currently working on an excel spreadsheet. i have data in one column. and data in the next. The first column contains sizes of our product. and the next contains the title.

Example. –

Column I

4 X 1/4

4 X 3/8

4 X 1/2

and so on..

Column J

Pozi Countersunk Self Tapping Screw

Ditto..

Instead of them being in two seperate columns, i need them in the same one so it will just read.. 4 X 1/4 Pozi Countersunk Self tapping Screw.

Is there anyway can do this without having to type it all out again. we have over 5000 items and im looking for an easy way to do this.

By: Emma

## You might also find helpful in Excel...

Hi there

Assuming column K is free and your data starts at row 2, the following should do what you are after…

Type in cell K2

`=I2&" "&J2`

Then pull the formula down to populate the cells beneath.

Thanks

Thankyou so much andrew, this worked perfectly!