| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unnecessary Space
Dear expert,
I have a a list of "if" criteria in row 1. If it is matched, it would show up the names in row 2. Then in A3 I use =A2&" "&B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2&" "&H2&" "&I2&" "&J2&" "&K2 to show a summary. (Real one is more lengthy and much longer) The outcome is a bit ugly which may have a lot of space in between. Some are separated by '5 Spacebar" and some are separated by "2 Spacebar". Can I skip the separation and summarize each name with only one spacebar distance please? This can be done in another cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unnecessary Space
Try
=TRIM(A2&" "&B2&" "&C2) -- Jacob "Elton Law" wrote: Dear expert, I have a a list of "if" criteria in row 1. If it is matched, it would show up the names in row 2. Then in A3 I use =A2&" "&B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2&" "&H2&" "&I2&" "&J2&" "&K2 to show a summary. (Real one is more lengthy and much longer) The outcome is a bit ugly which may have a lot of space in between. Some are separated by '5 Spacebar" and some are separated by "2 Spacebar". Can I skip the separation and summarize each name with only one spacebar distance please? This can be done in another cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unnecessary Space
It works....
Thanks "Jacob Skaria" wrote: Try =TRIM(A2&" "&B2&" "&C2) -- Jacob "Elton Law" wrote: Dear expert, I have a a list of "if" criteria in row 1. If it is matched, it would show up the names in row 2. Then in A3 I use =A2&" "&B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2&" "&H2&" "&I2&" "&J2&" "&K2 to show a summary. (Real one is more lengthy and much longer) The outcome is a bit ugly which may have a lot of space in between. Some are separated by '5 Spacebar" and some are separated by "2 Spacebar". Can I skip the separation and summarize each name with only one spacebar distance please? This can be done in another cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete unnecessary Named Ranges | Excel Discussion (Misc queries) | |||
| Delete Unnecessary Rows | Excel Discussion (Misc queries) | |||
| Unnecessary conversion | Excel Discussion (Misc queries) | |||
| hide unnecessary sheets when emailing to others | Excel Worksheet Functions | |||
| Using an XLT file which prints unnecessary 2nd page | New Users to Excel | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
