Best Blackhat Forum

Learn Functions/Formulas like Left, Trim, Clean, Proper, Substitute, Concatenate, VLOOKUP, Wildcards, Flashfill etc.

https://www.udemy.com/course/excel-text-functions-you-will-need-smash/


Peace, health and success! :)


Rating: 0.0 (0 ratings) 115 students
1hr 53min of on-demand video
CC English [Auto]

Created by João Appleton Ribeiro / IT Consultant, Project and Management Controller
4.6 Instructor Rating 54 Reviews 8,597 Students 2 Courses


:)

Coupon
https://www.udemy.com/course/excel-text-functions-you-will-need-smash/?couponCode=86F1D258A3931D16E989

This course includes:

2 hours on-demand video
3 downloadable resources



What you'll learn

Excel Text Functions and Formulas
Left, Mid, Right to extract text
Trim and Clean to Remove Unwanted Blank Spaces and non-printable characters
Proper, Lower, Upper for text capitalization
and Concatenate, Concat, Text Join
Difference between Substitute and Replace
Difference Between Find and Search
Len and Text
Isnumber Search Combination and More!
Extra: combination with VLOOKUP and wildcards!
Extra: Flashfill for replacing text functions! (this feature only exists from 2013 version onwards)