I have cells on a sheet now like for about 100 cities and suburbs.
Col A Col B
London orders
London Unit
London Damages
New York Orders
New York Units
New York Damages
..
I am trying to merge and centre like this for all of them .
to make them
Col A Col B
orders
London Unit
Damages
Orders
New York Units
Damages
can this be done with some code?
You get better help, posting an excel file without confidentional information.
Please also add the desired result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
"Orders" and "Damages" constant I mean always same?
aelgadi
> Click Star if I helped. Thanks
you can add cells together with =A1&" "&A2...
Does something like that work?
Last edited by Legend Rubber; 12-07-2012 at 07:45 AM. Reason: add =
Hi ,
please see attached Spreadsheet for explanation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks