How to Add the data from column B to column A on 12,000 lines?

[stingbaby01]

I am setting up data for my website and this is what I need to do:

I have 12,000 lines of product names in column A. Column B contains the product model number. I need to combine each product with the model number and add a a space and dash (-) between the product name and model number. see example below:

A: Fishfinder
Life Vest

B: 1234.01
L1245K

Here is how I need it to appear in column A: but for 12,000 lines so cant do it manually.
A:
Fishfinder - 1234.01
Life Vest - L1245K

Thanks for your help!

[TMS]

Add a Helper Column,say column C.

In C1 put the formula: =A1&" "&B1 and copy down.

Then select column C and copy the contents.

Select cell A1 and Copy | PasteSpecial Values

Delete column C

Done.


Is that what you are looking for?

Regards

[JBeaucaire]

Actually, to match his desired results, the formula would be:

=A1 & " - " & B1

[TMS]

@JBeaucaire: absolutely right, good spot.

[stingbaby01]

Thank You...that's what I needed

[TMS]

You're welcome.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.