We have additional free Excel training here 👉kzbin.info/aero/PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb & here👉kzbin.info/www/bejne/hp2zmIyFe6-Fhas & PivotTable training here 👉 kzbin.info/aero/PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc Check out our FREE 300+ hour training course playlist here ➡ 🔥kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@JHatLpoolАй бұрын
Nice, clear description. Thanks !
@SimonSezITАй бұрын
Thanks for watching 🙂 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@usmaniqbal18362 жыл бұрын
Perfect Simon, but also share link to download file for better practice
@georgepeterson9245 Жыл бұрын
How do you create a named range that includes AvgRev value
@danaraper96992 жыл бұрын
Hello!! Your videos have been very helpful. I Especially have used your excel tutorial videos. I have a question that i do not believe has been addressed. And, No one seems to know the answer - that I know of... I have exported my emails into an excel spreadsheet and one column of cells contains the email body. I found that the email body is where the date for the email appears. Its no where else in the extracted emails. How can I extract the date out of the email body column? The dates are in standard date format but the email does not have a specific format or consistent character length. In other words in the text in the email body column fluctuates and is all over the place... Any ideas?
@SimonSezIT2 жыл бұрын
Hi Dana! One solution I can think of is using either FIND and or SEARCH functions. So for example, you have a text in cell A1 that looks like this, with the date somewhere in the middle: Hello world 01/02/2022 Greetings! Given that your date has a standard length and format, you can try a formula that looks like this: =MID(A1,(FIND("/",A1,1))-2,10) You may use SEARCH in place of FIND and it will give the same result. The idea is to try to find the date within your text so you can extract it, but the limitation of this formula is if the character you are trying to search for (in this case the slash) appears within the text before the date. If the data is delimited, say comma-separated, you can also utilize the Text to Columns function in Excel. Hope this helps!
@danaraper96992 жыл бұрын
@@SimonSezIT thank you! I will definitely try this!!
@rayford86752 жыл бұрын
Nice one pal 😀!! You are late to the party > P r o m o s m !