How To Extract Data From Cells In Excel | #Shorts | Using LEFT and RIGHT in Excel

HOW TO EXTRACT DATA FROM CELLS IN EXCEL | #Shorts // Learn how to use the LEFT and RIGHT functions in Excel to extract the last four digits of a social security number and to extract the first five digits of a zip code. This method can be used anytime you need to extract data from cells.
__________
RESOURCES & GEAR

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
KEYWORDS: #Shorts, #MSExcel, how to extract data from cells in Excel, how to use LEFT function in Excel, how to use RIGHT function in excel, how to extract last four digits of social, how to extract first five digits of zip code, Excel formulas for HR, Excel tips and tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:

[archerpro]

I have been building a spreadsheet for a couple of years now. It's for construction project estimating. I manually input raw data such as measurements and quantities of materials on one sheet and I need that information to populate another sheet for the clients to see. The client cant see my raw data because of prices. Is this possible to have the data reorganize itself in a separate sheet in real time as I input raw data? Is there a name for such a thing? My head hurts.