[FREE Excel Course] Lesson 14 - Text Formulas in Excel

[@shaikhsaifuddin6547]

So useful this was...
Esp..Proper,find, replace & substitute...
Thanks 👍🏼

[@wayneedmondson1065]

Hi Sumit.. thanks for the review of TEXT functions in EXCEL. Thanks also for offering this useful and instructive course from free. Thumbs up!

[@HowToAnalyst]

Proper! Love this formula.

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@antarapal7029]

If you include the possible cases where some of these functions are used, then this course will be complete.

[@ellisiverdavid7978]

Oh, so that's how we do the "baby talk" feature 😂
*FORMULA:*
=SUBSTITUTE("Create formulas and spreadsheets, review your charts or start a budget on the go. Make spreadsheets and data files your way with robust formatting tools and great features. Excel lets you build your charts and spreadsheets to meet your specific needs.", "r", "w")
*OUTPUT:*
Cweate fowmulas and spweadsheets, weview youw chawts ow stawt a budget on the go. Make spweadsheets and data files youw way with wobust fowmatting tools and gweat featuwes. Excel lets you build youw chawts and spweadsheets to meet youw specific needs.

[@FRANKWHITE1996]

Thanks!

[@Ri_Mohammed]

Thanks a lot😮

[@himi1509]

Thanks Sir

[@amitjoshi8997]

Quality is not available or video is blurr how I will understand it ?

[@Wisal911]

thanks

[@KashifReads]

did you guys notice, the likes went down as the course progressed, many start but not all have the will to push through

[@trumpexcel]

Yeah many people start the course but drop off along the way

[@arunkumarpachaury3576]

in the cell of formula how formula is remain visible..
is this screenshot or how did you do that please revert...

[@adetutu4413]

Hello there! One question on REPLACE FUNCTION pls, if i want to extract names from email addresses and start number isnt consistent in all the data, whats the best function to do that ? Thank you for your response !

[@CassieTang-l6p]

did you ever get an answer to this?

[@adetutu4413]

@@CassieTang-l6p i didn’t pls

[@CassieTang-l6p]

@@adetutu4413 he explains how to do it in lesson 16 btw

[@MokshagnaGoudK]

H for hydrogen and He for Helium
Chemistry students can understand

[@ankitnayal6091]

whats the diiference between substitute and replace?

[@jeremiahv6498]

As stated on Excel " Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string."

[@adeelanwar9311]

What is the formula for searching multiple words in data. I want to Seach or compare data starting with these intents ( how what if buy etc )

[@wayneedmondson1065]

Hi Adeel.. assuming you have a text string in cell A1, the following formulas (either one) entered in a cell would produce TRUE if any or all of the above words were found in the string in A1 and FALSE if not found:
=OR(COUNTIF(A1,"*how*"),COUNTIF(A1,"*what*"),COUNTIF(A1,"*if*"),COUNTIF(A1,"*buy*"),COUNTIF(A1,"*etc*"))
or..
=SUMPRODUCT(--ISNUMBER(SEARCH({"how","what","if","buy","etc"},A1)))>0
Using the SUMPRODUCT formula, you could put the list of words you want to search in a range on the worksheet such as C1:C5 and replace the array constant {"how","what","if","buy","etc"} with the coordinates of the range, as in:
=SUMPRODUCT(--ISNUMBER(SEARCH(C1:C5,A1)))>0
I'm sure there are other ways to set this up. But, the formulas above work as described, assuming I understood your question. Good luck!

[@City-reflection]

use the find formula

[@OscarRamirez-q7p]

Just use, find function.

[@amanbeniwal1576]

Most are of no use probably except find / Replace.