58.gif

Search (advanced search)
Use this Search form before posting, asking or make a new thread.
Tips: Use Quotation mark to search words (eg. "How To Make Money Online")

01-25-2021, 05:31 AM (This post was last modified: 01-25-2021 05:32 AM by angelcrc7.)
Post: #1
[F4LT] Excel Text Functions You Will Need - SMASH!
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


:)
More FREE courses? Get the browser extension shared in my profile! (created by Patrick0 and highly recommended by angelcrc7)
https://bestblackhatforum.com/User-angelcrc7

angelcrc7
01-30-2021, 10:57 AM
Post: #2
RE: [F4LT] Excel Text Functions You Will Need - SMASH!
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)




76.gif