How to insert a space between display results

N

Neall

I am using this "IF" statement and I want the "IF True" to return data from 2
different cells. This is working however there is no space between the data
so "Customer_List!A121 & Customer_List!P121" shows up as Acme10000 and I want
it to display as Acme 10000.


=IF(Customer_List!N121>50,Customer_List!A121 & Customer_List!P121,"")

Any help would be appreciated
 
M

Mike H

Concatenate a space:-

=IF(Customer_List!N121>50,Customer_List!A121 & " " & GCustomer_List!P121,"")

Mike
 
G

Gord Dibben

=IF(Customer_List!N121>50,Customer_List!A121 & " " & Customer_List!P121,"")


Gord Dibben MS Excel MVP
 
Top