Hello,
I have a cell which has data separated by "_" for example _11_G_1_B_0_0_, I need to separate this data. It will split as 11, G, 1, B, 0, 0, (Blank Cell), next set of 6 cells and a blank cell again. After the split I want to cut every 6 rows and align them under each other. The 0's must be blank and finally a column inserted after the first cell. Example attached...
Thanks!
SplitCell.xlsx
This macro will accomplish what you describe, though my results from your data are not exactly the same. This should get you close enough to make final edits easier.
Please Login or Register to view this content.
How/Where to install the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The macro is installed and ready to use.
a) Make sure your data is on the activesheet listed in column A
b) Press Alt-F8 and select SplitData from the macro list.
Last edited by JBeaucaire; 01-05-2015 at 08:33 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks