Okay, so, for example: I have "ABCDEFGHIJKLMNOPQRSTUVWXYZ" on copy and paste. How do I paste that into A-Z columns?
At the moment, if I highlight A-Z columns it just copy and pastes it all into the A column. But I need it so that it has A in the A column, B in the B column, C in the C column, and so on to Z.
Any ideas how I could do that?
You can use text to columns - Fixed width option. But you will have to put a pointer in place for each alphabet which can be tedious.
There should be formulae which can help you as well.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Welcome to the forums
Please place this in Column A (given cell containing text is A1)
=MID($A$1,COLUMN(),1)
and drag it across the columns, please tell me if this is what you are looking for.
Hope it helps!
SC
Do give a * (bottom left) if the post helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks