concatenate

[babs]

=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]

=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]

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]

Make sure you have excel in autocalculate mode.

Tools|Options|Calculation tab (in xl2003)

 

[macropod]

Hi Barb,

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

Cheers

 

[Excel Ranger]

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).