Dear All
Column A contain text apple, after vba code , the answer should as coloum B
That is after VBA code
keep the word in front of "apple", after "apple" delete all word
Our attached file with vba don’t work. Please help
Thanks
Tom
Dear All
Column A contain text apple, after vba code , the answer should as coloum B
That is after VBA code
keep the word in front of "apple", after "apple" delete all word
Our attached file with vba don’t work. Please help
Thanks
Tom
Hello Tom,
Or:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by HSV; 06-03-2018 at 10:36 AM.
Kind regards, Harry.
Also can be done with a formula
Enter formula in B1 and copy down
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
v A B 1 abcdeappleiamstupid abcdeapple 2 defgaappleiam a boy defgaapple 3 apcdeapple apcdeapple 4 dddddappleihave a dream dddddapple
Last edited by AlKey; 06-03-2018 at 10:53 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
hi attached will file, if we separte one row ,,,some row ..the vba code cannot work. pls help
many thank
tom
Please Login or Register to view this content.
hi ..thank for your help after add the code, the attached file dont work
is it the right place to add,pls help
Hello,
delete:
Please Login or Register to view this content.
perfect and good job. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks