✅ Download the file | www.exceleinfo.com/caso-real-f...
🏆 Subscribe | goo.gl/M5zNA8
In this tutorial, he answers a practical case that a subscriber of our KZitem Channel has proposed to us. He tells us that he receives a database every day where different texts are included in a field, and among these texts is the telephone number. The number is preceded by the text "telephone:".
To solve this case we will use formulas and functions in Excel, as well as VBA macros to give a second solution. Both solutions are valid. You choose which one to take.
Functions in Excel to extract text
We have the following example text in which we will apply a couple of functions to return a text within the cell.
"Withdraw document from Av. Luis Albeto 125, ask at reception, telephone: 123-456789, only from 8:00 a.m. to 10:00 p.m."
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/exceleinfo
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinfo.com
Photo by Melinda Gimpel on Unsplash
#Excel #MsExcel #VBA
Негізгі бет Real case: Formulas and VBA to return text from cells @EXCELeINFO
Пікірлер: 42