How to insert a space between display results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Concatenate a space:-

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

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you add conditional formatting to columns that are linked? 3
If cell value is between XX and XL, display B 4
How to check if time falls between two ranges 0
Find/replace using wild cards to insert space between given characters 1
Extracting Data From The Right of a Cell 1
change the color of cell background based on a result 2
How to remove space from a cell. 15
E2007 formulas display as formulas, not results 3

Back
Top