Hi,
I need to write a vba code to remove all characters after "day" in a column. I cannot use Right or Left function.
For example,
May 2, 2013 Thursday First Edition
May 1, 2013 Wednesday 1 - SYD Edition
Output:
May 2, 2013 Thursday
May 1, 2013 Wednesday
Thanks,
Ling
Using Worksheet Functions:-
In A1 Cell
May 2, 2013 Thursday First Edition
In B1 Cell
Formula:
Please Login or Register to view this content.
Using VBA
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
where a1 = cell to cutPlease Login or Register to view this content.
Last edited by humdingaling; 05-23-2013 at 03:58 AM. Reason: ...too slow
Please Login or Register to view this content.
If solved remember to mark Thread as solved
thought user said cannot use Left or Right
User said "cannot use Left or Right" AND user said "need VBA code"
so, try below
Please click the * below if this helpsPlease Login or Register to view this content.
touché
well played
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks