I HAVE MANY EMPTY CELL IN RANDOMLY. HOW TO REMOVE THAT, ALSO I DON'T WANT REMOVE SPACE BETWEEN TWO WORDS. JUST I WANT TO CLEAN EMPTY CELLS.. I CANT UNABLE TO MAKE PVOT TABLE. BECAUSE PVOT CALCULATE EMPTY CELL AS VALUE,
SEE MY EXAMPLE FILE, B COLUMN IS JUST APPEAR AS EMPTY CELL, BUT TRUTH IS B IS NOT EMPTY,HOW TO SOLVE.
I HAVE MANY DATA'S LIKE THIS IN SINGLE EXCEL, JUST I GIVEN SAMPLE EXCEL IN THIS THREAD..
Perhaps a macro like this to "trim" column B?
Alf
Please Login or Register to view this content.
i don't know about macro.. is there another way ?>...
Here is how to install your macro and run it. Give it a try. It will save you lots of time and effort and you will probably want to learn more about them once you find out how fast and easy they operate.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
yes alansidman, i tried many time time macro, i coudn't understand, but now i tried as you said, its working, i want learn more.. i dont know how to use macro give me some simple VBA code to workout myself. thanks..
hi alf, your code is working well. i tried your program its first time to me, nice thank you..
Glad to be of help and thanks for feed back.
Alf
Ps If this solves you problem don't forget to mark thread "Solved"
Here is a link to a pretty good intro YouTube Video. You can find more YouTube videos by searching for what you want to do specifically.
http://www.youtube.com/watch?v=7RVGdA9AhrY
hi alf, and alansidman, i just tried macro recording, wow wow its wonderful i didn't expect all this magic in excel. amazing.. i want learn more.. thanks for introducing macro..
Last edited by vengatvj; 10-19-2013 at 05:24 PM.
how to remove shortcut keys. i save in personal macro workbook, i want remove all shorcut keys. i kept shortcut for just i learning purpose..
Click on Alt + F8. Macro window opens. Click on Options. Remove the data in the Shortcut key textbox
THIS IS HAPPEN when i delete " cannot edit a macro on a hidden workbook. unhide the workbook using the unhide command"
Perhaps this link will help?
http://office.microsoft.com/en-us/he...#BMdeletemacro
Check part "Delete a macro"
Alf
this vba code for deleting B column empty or blank cell, i want like this to do more column delete blank cell, that columns are H, K, N, Q, S, YPlease Login or Register to view this content.
I dont know how to create vba, i know only macro recording..
I want to make sure I understand. Do you wish to have code to delete columns H, K, N, Q, S and Y? You cannot delete a blank cell with out moving cells that are adjacent to it. Please explain with a clear example of what you are trying to do.
hai, in my orginal excel i have formula's in H, K, N, Q, S and Y colomn, formula give result in some cells only. other cells appear blank, but truth is really all the cells is not blank. so i cant make pivot. in pivot table calculate blank cells as value. after that i delete blank cells in this H, K, N, Q, S, Y column then pivot table give correct value.
Not to happy about this macro still it works but it should be possible to write a more "condensed" macro,
AlfPlease Login or Register to view this content.
thank you boss, i tried your vba, and learnt i want insert this vba in another one vba which one is my recorded macro vba, i will try to insert,
After fiddling around a bit I've managed to "compress" the previous macro. The string "sNam" contains the letters for the columns you wish to trim. Should you wish to trim other columns just change the letters in "sNam".
AlfPlease Login or Register to view this content.
wow super nice. its working and deleting empty space, thank you so much, very thanks a lot, i need simple program like this, just share here more for basic useful, thank you dear friend..
Last edited by vengatvj; 10-28-2013 at 11:34 AM.
pls share some program like this, basic useful,
Last edited by vengatvj; 10-28-2013 at 11:34 AM.
Glad to be of help and thanks for your kind words!
As this problem now seems "Solved" could you pleas mark this thread "Solved"
Alf
PsTo mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks