=Concatenate(A2,"",C2,"",E2)
or more simply:
=Concatenate(A2,C2,E2)
or even
=A2&C2&E2

But it doesn't look like E2 is formatted as General--or did you type '011 (with
the leading apostrophe)?

You may want something like:
=text(a2,"0000")&text(c2,"0000")&text(e2,"000")



babs wrote:

=Concatenate(",A2,"",C2,"",E2,")

a2 c2 e2 f2
2378 7011 011 =Concatenate(",A2,"",C2,"",E2,")

I am trying to tie together fields that are formatted as general. I am
using the above concatenate formula but keep just seeing the actual formula
and not the numbers that I want to see.

What am I forgetting or putting in wrong???

Thanks,
Barb

--

Dave Peterson

thanks for the input. It worked for the first one F2 but then when I use the
fill handle to copy down. It appears that the formula changes to where it is
copied to - relative- which is what I want put the actual result of the
forumula matches exactly what is in F2 not what is should in the
corresponding cells????

can't figure this out??

Thanks again,
Barb

"Dave Peterson" wrote:

=Concatenate(A2,"",C2,"",E2)
or more simply:
=Concatenate(A2,C2,E2)
or even
=A2&C2&E2

But it doesn't look like E2 is formatted as General--or did you type '011 (with
the leading apostrophe)?

You may want something like:
=text(a2,"0000")&text(c2,"0000")&text(e2,"000")



babs wrote:

=Concatenate(",A2,"",C2,"",E2,")

a2 c2 e2 f2
2378 7011 011 =Concatenate(",A2,"",C2,"",E2,")

I am trying to tie together fields that are formatted as general. I am
using the above concatenate formula but keep just seeing the actual formula
and not the numbers that I want to see.

What am I forgetting or putting in wrong???

Thanks,
Barb

--

Dave Peterson

Make sure you have excel in autocalculate mode.

Tools|Options|Calculation tab (in xl2003)



babs wrote:

thanks for the input. It worked for the first one F2 but then when I use the
fill handle to copy down. It appears that the formula changes to where it is
copied to - relative- which is what I want put the actual result of the
forumula matches exactly what is in F2 not what is should in the
corresponding cells????

can't figure this out??

Thanks again,
Barb

"Dave Peterson" wrote:

=Concatenate(A2,"",C2,"",E2)
or more simply:
=Concatenate(A2,C2,E2)
or even
=A2&C2&E2

But it doesn't look like E2 is formatted as General--or did you type '011 (with
the leading apostrophe)?

You may want something like:
=text(a2,"0000")&text(c2,"0000")&text(e2,"000")



babs wrote:

=Concatenate(",A2,"",C2,"",E2,")

a2 c2 e2 f2
2378 7011 011 =Concatenate(",A2,"",C2,"",E2,")

I am trying to tie together fields that are formatted as general. I am
using the above concatenate formula but keep just seeing the actual formula
and not the numbers that I want to see.

What am I forgetting or putting in wrong???

Thanks,
Barb

--

Dave Peterson


--

Dave Peterson