Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If I format a formula with carriage returns and spaces for clarity,
any carriage returns or spaces right before a comma are removed by Excel. For example, if I do this: (Yes, I realize this formula doesn't make sense; it's just a simple example to illustrate the problem.) =IF( OR( TRUE,TRUE ) ,TRUE,TRUE ) As soon as press Enter, Excel changes it to this: =IF( OR( TRUE,TRUE ),TRUE,TRUE ) That happens with carriage returns right before commas, spaces right before commas, and any combination of them right before commas. Is there any way around that? The best I've been able to do is just do the formatting after the comma instead of before it: =IF( OR( TRUE,TRUE ), TRUE,TRUE ) Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Password Protect Sheet with formatting allowed | Excel Discussion (Misc queries) | |||
commas in formulas | Excel Discussion (Misc queries) | |||
Number of "array" Formulas Allowed? | Excel Discussion (Misc queries) | |||
Formatting and seperating commas | Excel Discussion (Misc queries) | |||
delete commas in spreadsheet but not in formulas | Excel Discussion (Misc queries) |