Thread: concatenate
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Excel Ranger Excel Ranger is offline
external usenet poster
 
Posts: 3
Default concatenate

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