wont paste special> transpose achieve the same thing?
I want to compose a formula that will result in not only combining some cells together but also will insert a carriage return in some spots. However, I don't know how to do this.
If A1 = Joe Smith, A2 = President, A3 = ABC Company
I want to create a formula in A4 that concatenates the three cells and produces
which I can later copy and paste into other applications to use.
What would that formula look like?
This formula in A4 but you need to set Wrap text on otherwise you will just see little white boxes between the items.
VB:=A1 & CHAR(10) & A2 & CHAR(10) & A3
There are currently 2 users browsing this thread. (0 members and 2 guests)