Could someone provide the code to do the following macro activity.
I need to edit a cell, have the cursor go the very beginning of the cell and delete the first space, hit enter to accept and go down one cell.
Thanks for any help
Could someone provide the code to do the following macro activity.
I need to edit a cell, have the cursor go the very beginning of the cell and delete the first space, hit enter to accept and go down one cell.
Thanks for any help
Last edited by tdf2437; 11-12-2010 at 12:43 PM. Reason: solved
Maybe:
Please Login or Register to view this content.
Or if you're trying to clean up all the stray spaces before and after the string:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon 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!)
are you saying you want to delete the first space that it finds in the cell so..
John Smith Barrymore
would become
JohnSmith Barrymore
Did you try the suggestions in post #2?
So I believe the first code from JBeaucaire is exactly what you are looking for.
yes, it worked... thanks for the help!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks