Thread: Spaces
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Spaces
Maybe...

=trim(a1&" "&b1&" "&c1)



wrote:

Hi
Anyone can help
I have this problem in this formula
A B C D
1 Olives Chili Cumin
2 12 19 15
=IF(A2<20;$A$1;"")&IF(B2<20;$B$1;"")&IF(C2<20;$C$1 ;"")
What I get is Oiveschilicumin without spaces in between, how to have
the spaces in this formula
Thanks in advance
Jam

--

Dave Peterson
Reply With QuoteReply With Quote