| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display white space characters in excel? | Excel Discussion (Misc queries) | |||
| Insert Space | Excel Discussion (Misc queries) | |||
| add space between the results of a formula and text | Excel Discussion (Misc queries) | |||
| How do I insert space between 2 consecutive columns of an XL Shee. | Excel Discussion (Misc queries) | |||
| insert a space in a phone #. change (123)456-7890 to (123) 456-78 | Excel Worksheet Functions | |||
Hybrid Mode
