In Excel 98 and in Office 2000 How to concatenate two separate cells into one

[Steven North]

Using the Concatenate function I would do it this way.
A)
=CONCATENATE(A1,B1) Which would result in
99999XXXXX-999-99
B)
=CONCATENATE(A1," ",B1) Which would result in
99999 XXXXX-999-99
C)
=CONCATENATE(A1,"-",B1) Which would result in
99999-XXXXX-999-99

You can replace A1 & B1 with the cell references of your
choice.

-----Original Message-----
I am an auditor faced with the problem of having two

separate columns of data (a major account number = 5
characters long all numeric and a separate column of data
that looks like this XXXXX-999-99 (where the X symbolizes
either an alphabet letter or the number 0. The 9's all
symbolize numerics with dashes between them as shown.

I need to bring these two separate columns of data

together into a single column of data so that I might
export the resultant single column of data which now would
contain both the main and the associated subsidiary
account number assigned to each main account.

Again pictorally what I am attempting to do is this:

A) Given two separate columns of data

99999 and XXXXX-999-99

I need to bring them together into a single column

without spaces 99999XXXXX-999-99

B) Given two separate columns of data

99999 and XXXXX-999-99

I need to bring them together into a single column

with a space between them like so 99999 XXXXX-999-99

C) Finally given two separate columns of data

99999 and XXXXX-999-99

I need to bring them together into a single column

with a dash in between them like so 99999-XXXXX-999-99