Unnecessary Space

E

Elton Law

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top