Need VBA Code

0

Hello everyone

can i have vba code for REGEXEXTRACT function in excel 2013

Answer
Discuss

Discussion

This looks like it's for Google Sheets. Can you explain what it's supposed to do, or, better, what you specifically need it to do? It sounds like there might already be code on TeachExcel that can help, I'm just not sure exactly what you're trying to do.
don (rep: 1725) Jan 3, '19 at 12:03 am
Actually, this function 'REGEXEXTRACT' is not available in Excel, I need to do a lot of data by using this.
It so boring to do in google sheet because there is the limitation of rows, So I need it in excel 2013, Please help me if you able to do

Thanks   
devendrapaliwal Jan 4, '19 at 11:12 pm
Certainly, just tell me what you want it to do in Excel.
don (rep: 1725) Jan 8, '19 at 11:13 am
Hello Don,
I have a string " See more of VKitchen - Vietnamese Cuisine on FacebookLog InorCreate New AccountSee more of VKitchen - Vietnamese Cuisine on FacebookLog InForgot account?orCreate New AccountNot NowAboutSuggest EditsFIND US883 W Eisenhower PkwyAnn Arbor, MichiganGet DirectionsCall (734) 930-1988HOURSClosed Now11:00 AM - 9:30 PMBUSINESS INFOBusiness DetailsCuisinevietnameseParkingParking Lot parkingPrice Range$$SpecialtiesServes lunch and dinnerServicesTakes Reservations Walk-Ins Welcome Take Out Delivery CateringStarted on September 29, 2015cardCASHADDITIONAL CONTACT INFOvkitchen.annarbor@gmail.comhttp://www.vkitcheninc.comMORE INFOAboutThe First Authentic Vietnamese Restaurant in Ann Arbor. Must try our Pho (Vietnamese beef noodle soup) and Banh Mi (Vietnamese sandwich.)categoriesPho RestaurantEnglish (US)EspañolFrançais (France)中文(简体)العربيةPortuguês (Brasil)Italiano한국어Deutschहिन्दी日本語Sign UpLog InMessengerFacebook LiteMobileFind FriendsPeoplePagesPage CategoriesPlacesGamesLocationsMarketplaceGroupsInstagramLocalAboutCreate AdCreate PageDevelopersCareersPrivacyCookiesAd ChoicesTermsAccount SecurityLogin HelpHelpSettingsActivity Log Facebook © 2018 ". I need to extract address, phone and email from string.

Address
:- 883 W Eisenhower PkwyAnn Arbor, Michigan
Phone
:- (734) 930-1988
Email:- vkitchen.annarbor@gmail.com
(edited for better understanding)
Thanks
devendrapaliwal Jan 8, '19 at 11:19 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login