CONCATENATE() feature

[sweetsupra]

Hey guys,

I got a question about concatenate() function. I have an excel wooksheet which has 2 fields that I want to combine and transport it into access database. For Example:

Column 1 Column 2
22 001
22 002
22 010
33 011
55 051
66 101
77 110
88 210



My question is what is the easiest and most efficient of concatenating it? Currently, I have the 2 columns as text so I can have the leading zeros if necessary.

The "&" symbol in Access truncates the leading zeros. So, I tried by sticking "0" in the middle, but access is dropping the trailing number in the ends.

I was looking at excel about Concatenate() function. I took the relevent columns and made a seperate sheet. The third column would have the concatenated field. I thought it was simple plugging in the cells that I wanted to concatenate. But it is only displaying the function(formula) and NOT the answer. Note: I have both columns as text to display the leading zeros.

Any Solutions?

Thanxs in advance ,

Manoj

[PilgrimPete]

Probably a stupid question (so I apologise in advance), but have you remembered to put the equals sign before the Concatenate()?

i.e.
=CONCATENATE(B1,C1)
not
CONCATENATE(B1,C1)

[drekab]

It sounds like your data type in Access is number of some sort. If it is text it shouldn't drop anything. Also, if you are concatenating in Excel you can use the '&' sign instead of Concatenate().

C1=A1&B1