Extract text/ number AFTER last space in Excel
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Extract amounts from rows with no delimiter
00:11 Find the rows in Excel that contain your data
00:21 Use SEARCH function to find the correct rows
00:53 Change #VALUE error message after FIND/ SEARCH function
01:50 Find the character number of the LAST space in the Text (just before the amount)
03:38 Differentiate the last space to make it searchable
04:52 Use FIND to extract the character number of last space
05:30 Extract the text (number) after the last space
06:03 Force a number to be seen after using LEFT. RIGHT & MID functions
Clever way to use the text functions in Excel to pull out the costs of only certain rows (faxes in this case) where there is no reliable delimiter and you need to look for the last space in the text because after the last space in the amount you are looking for.
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
Смотрите видео Extract text/ number AFTER last space in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь AuditExcel Advanced Excel and Financial Model Training and Consulting 27 Апрель 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 891 раз и оно понравилось 4 людям.