Hi, My problem is that I have two colums of data in a worksheet, the first is
a prefix to the part number
i.e. AB
The second is a part number
i.e. 123456789

My list is 8800 numbers long and I want a quick way to merge these comuns
together but keep the rows.

Thankyou in advance,
Andrew

P.S. don't know if it's important but running XP Pro SP2 and Office 2003

Hi, Andrew. Here ya go:
--click the column letter to the RIGHT of your 2 columns and hit
Insert--Column.
--select the new blank column and make sure it's formatted as General
--in the new blank column, probably the 2nd row if you have headings, type
=A2&B2
Copy down using the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm
Then, with all the cells STILL selected, hit Copy. Hit Edit--Paste Special,
choose Values, OK.
Then delete your original columns.
************
Anne Troy
www.OfficeArticles.com

"Andrew" wrote in message
...
Hi, My problem is that I have two colums of data in a worksheet, the first
is
a prefix to the part number
i.e. AB
The second is a part number
i.e. 123456789

My list is 8800 numbers long and I want a quick way to merge these comuns
together but keep the rows.

Thankyou in advance,
Andrew

P.S. don't know if it's important but running XP Pro SP2 and Office 2003

Thankyou Anne for your help, problem solved

"Anne Troy" wrote:

Hi, Andrew. Here ya go:
--click the column letter to the RIGHT of your 2 columns and hit
Insert--Column.
--select the new blank column and make sure it's formatted as General
--in the new blank column, probably the 2nd row if you have headings, type
=A2&B2
Copy down using the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm
Then, with all the cells STILL selected, hit Copy. Hit Edit--Paste Special,
choose Values, OK.
Then delete your original columns.
************
Anne Troy
www.OfficeArticles.com

"Andrew" wrote in message
...
Hi, My problem is that I have two colums of data in a worksheet, the first
is
a prefix to the part number
i.e. AB
The second is a part number
i.e. 123456789

My list is 8800 numbers long and I want a quick way to merge these comuns
together but keep the rows.

Thankyou in advance,
Andrew

P.S. don't know if it's important but running XP Pro SP2 and Office 2003

Cool beans! Thanks for the feedback.
************
Anne Troy
www.OfficeArticles.com

"Andrew" wrote in message
...
Thankyou Anne for your help, problem solved

"Anne Troy" wrote:

Hi, Andrew. Here ya go:
--click the column letter to the RIGHT of your 2 columns and hit
Insert--Column.
--select the new blank column and make sure it's formatted as General
--in the new blank column, probably the 2nd row if you have headings,
type
=A2&B2
Copy down using the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm
Then, with all the cells STILL selected, hit Copy. Hit Edit--Paste
Special,
choose Values, OK.
Then delete your original columns.
************
Anne Troy
www.OfficeArticles.com

"Andrew" wrote in message
...
Hi, My problem is that I have two colums of data in a worksheet, the
first
is
a prefix to the part number
i.e. AB
The second is a part number
i.e. 123456789

My list is 8800 numbers long and I want a quick way to merge these
comuns
together but keep the rows.

Thankyou in advance,
Andrew

P.S. don't know if it's important but running XP Pro SP2 and Office
2003