How to insert a space between display results
 

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!N12150,Customer_List!A121 & Customer_List!P121,"")

Any help would be appreciated

--
Neall

How to insert a space between display results
 

Concatenate a space:-

=IF(Customer_List!N12150,Customer_List!A121 & " " & GCustomer_List!P121,"")

Mike

"Neall" wrote:

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!N12150,Customer_List!A121 & Customer_List!P121,"")

Any help would be appreciated

--
Neall

How to insert a space between display results
 

=IF(Customer_List!N12150,Customer_List!A121 & " " & Customer_List!P121,"")


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 07:28:01 -0700, Neall
wrote:

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!N12150,Customer_List!A121 & Customer_List!P121,"")

Any help would be appreciated