Extract date number and income from text string with fixed width | Excel Tips #24
In this video you will see how you can extracted date number and income from text string with fixed width. We will be using the MID function. We have to remember that MID function just like all text functions returns text. So sometimes we have to convert text to number or date using simple mathematical operation. Excel Tips #24
MID function isn't returning errors when she extract more signs than text string length.
Formula used in this video:
=MID(A2,8,8)+0
Excel SuperHero book: https://www.amazon.com/dp/B0B49CRTV6
00:00 | Intro
00:20 | Extracting date from text - MID function fixed length
02:59 | Extracting number from text start - leading zeros (convert text to number)
04:18 | Extracting income from text end - more signs than length of the text
06:30 | Adding currency number format
06:45 | Summary
#excel #mid #texttonumber
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube