View Single Post
  #2   Report Post  
Ray A
 
Posts: n/a
Default

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.