The result of a CONCATENATION is a TEXT string........

From Help.....
CONCATENATE
Joins several text strings into one text string.
Syntax:
CONCATENATE (text1,text2,...)
Text1, text2, ... are 1 to 30 text items to be joined into a single text
item. The text items can be text strings, numbers, or single-cell
references.

Of course, concatenated numbers can be stripped back out of a string and
returned to number status.......

Vaya con Dios,
Chuck, CABGx3


"sunslight" wrote in message
...
Thank you both.

I will try and see if these will work for me.

What I forgot to state, is that the concatenation must not turn the
numbers
into text. The numbers must stay numbers. (I tried a TEXT(x,"00")) type
formula. It put everything together, but I had all text instead of text,
numbers, text.

Bob

"Dave Peterson" wrote:

in D2:
=$a$1&text(b2,"0000")&$c$1
dragged down

Or maybe:
in D2:
=$a$1&text(row()-1,"0000")&$c$1





sunslight wrote:

I need a formula to concatenate A1,B#,C1; and place the result in D2,
D3, D...

A B C D
1 dog100 0000 red ""
2 0001 dog1000001red
3 0002 dog1000002red

A1: Does not change its location. It is an absolute reference.
It is in general format, a combination of text and a number. It is
imported
that way.

B2: is a custom format number of the form "0000". I have to keep all
the
digits. It is derived from a formula to increment the # in the
previous
column, by one.

C3: Does not change its location. It is an absolute reference.
It is Text.

What I want is to end up with D2, D3,.. a combination of text and
value,
derived by combining A1,B...,C1.
Then copy the formula down the D column, so it will referentialy
calculate
the next answer.

Can someone help me put together text + numbers that increment?

Thanks,
Bob

--

Dave Peterson