View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I combine dollars and text

I suspect the $ sign in a2 is a format so try this

=TEXT(A2,"$"&0)&" "&A3

Mike

"Kesbutler" wrote:

I want to combine two different cells that contain dollars and text. when I
try it always drops the $ sign. How do I do this? Example cell A2=$40 and
cell A3 is per year, I want in one cell $40 per year.