| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spaces
Hi
Anyone can help I have this problem in this formula A B C D 1 Olives Chili Cumin 2 12 19 15 =IF(A2<20;$A$1;"")&IF(B2<20;$B$1;"")&IF(C2<20;$C$1 ;"") What I get is Oiveschilicumin without spaces in between, how to have the spaces in this formula Thanks in advance Jam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
| Spaces in cells | Excel Worksheet Functions | |||
| How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
| spaces not recognized as spaces | Excel Worksheet Functions | |||
| Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions | |||
Threaded Mode
