Advanced Excel Tutorial: Extracting Dates, Amounts, and Descriptions (Text Formulas)

preview_player
Показать описание
QuickBooks 30-day free trial + 30% off for 12 months:

Formulas used:
RIGHT()
LEFT()
SUBSTITUTE()
FIND()
TRIM()

  1. Hector Garcia CPA
  2. excel
  3. advanced
  4. accountants
  5. dates
  6. amount
Рекомендации по теме
Advanced Excel Tutorial: 0:14:20

Advanced Excel Tutorial: Extracting Dates, Amounts, and Descriptions (Text Formulas)

Advanced Excel Tutorial: 0:03:08

Advanced Excel Tutorial: Using FlashFill to extract Dates, Amounts, and Descriptions

Effortlessly LOOKUP ALL 0:09:13

Effortlessly LOOKUP ALL values between two dates (return many match results)

Excel Hacks: Extracting 0:00:15

Excel Hacks: Extracting Data Made Easy 📊 #dataextraction #excel

Remove Time from 0:00:46

Remove Time from Date Timestamp (2024)

Excel VBA Macros: 0:00:33

Excel VBA Macros: Data Entry Made Easy with These Tips and Tricks

XLOOKUP function in 0:00:41

XLOOKUP function in #excel better than VLOOKUP

Master the Advanced 0:00:43

Master the Advanced Filter Function in Excel: Step-by-Step Guide

How to Extract 0:01:01

How to Extract Text and Numbers from a String in Excel | LET + SEQUENCE + MID Formula Trick

Excel Tutorial to 0:04:37

Excel Tutorial to Quickly Reconcile two sets of Data

Today Formula in 0:00:15

Today Formula in Excel

Change number in 0:00:24

Change number in date format | Excel formulas | Text Function

Sumifs formula in 0:00:18

Sumifs formula in excel | Excel formula #shorts #sumifs

Python in Excel‼️ 0:00:29

Python in Excel‼️ #excel #python

How to Make 0:00:41

How to Make a Graph in Excel

Don't Consolidate Data 0:01:01

Don't Consolidate Data Manually in Excel‼️Instead Use Amazing Trick |Day 21 | Learn Excel #exce...

Excel FILTER Function 0:00:33

Excel FILTER Function

Excel tip advanced 0:00:12

Excel tip advanced filter unique values

Calculate quarter from 0:00:13

Calculate quarter from a date in excel #excel #shorts #exceltips

Job Interview : 0:00:38

Job Interview : Excel Assessment #viralshorts #excelshorts

Find duplicates from 0:00:27

Find duplicates from two separate lists in Excel with Conditional Formatting! #excel #exceltips

How to Count 0:00:41

How to Count Distinct Values In Excel #excel

Excel Advanced Filter 0:01:00

Excel Advanced Filter or Criteria | How to use advanced filter in excel | Dynamic Filter

How to Pull 0:03:56

How to Pull Data Between Two Dates to Another Sheet in Excel (Using FILTER!)

Комментарии
Автор

I have an invoice I converted to excel. And the description contains multiple type of woods with different percentages. I wanted to extract the wood percentage to another column but I don't how to do it so I just manually type it. Will you be able to show us how to extract because it is so time consuming and I'm already tired typing for long invoices?

savagemaster
Автор

Hi! I would like to know for example there's currency before the number (amount) and I want the amount not included in the description? how can I do with the formula? Badly need help! Thanks.

PerkyStar
Автор

I only use the Data Tab then text to column, delimited and then tick space. This is too much for my braincells but well this is fun. Thank you very much for sharing this.

sky_gaming
Автор

Why don't you use power query for this purpose hector.

qasimjan
visit shbcf.ru