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.

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.

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.