How to append a series of cells in a fast manner for an Excel worksheet
I need to append or concatenate cell J3 thru LN3.
I can do it mannual like so:
=J3&K3&L3&M3&N3&O3&P3&Q3&.
Is there a function or a way to do it faster?
I can do it mannual like so:
=J3&K3&L3&M3&N3&O3&P3&Q3&.
Is there a function or a way to do it faster?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx
=CONCATENATE(J3:Q3)