=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

=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

Hi Barb,

Make sure the cell is not formatted as Text (see under Format|Cells) - use the General or another suitable format instead.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"babs" wrote in message ...
=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

Do you want the output to look like 23787011011, or 2378 7011 011?
If it were me doing this, I would format as General and the formula would be :
=a2&c2&e2 (for no spaces inbetween)
=a2&" "&c2&" "&e2 (for the spaces inbetween).

"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