One way
In cell f2 use formula =a2&b2&c2&d2&e2 copy the formula down. Then
copypaste specialvalues. You may then delete columns A:E
HTH
"Lu" wrote:
I need to upload Excel file into another system.
Part of my Excel file looks like that:
A B C D E
1 Account
2 410. 05 107 110. 9995200
3 410. 05 107 110. 1004300
how can I combine the data from cells A--E into one account like that:
410.05107110.9995200 ?
Thanks for your help,
Lu.
|