Extract text from cells in excel - how to get any word from a cell in excel

In this video I’m going to show you way to Extract text from cells in excel - how to get any word from a cell in excel. Infact, this is one of the best ways to extract text from cells in excel.

This method becomes particularly handy when you have some data in parenthesis and you don't know how to extract it and especially when the excel file is huge.
SUBSCRIBE to get more excel videos!

#ExcelFormulas #tutorial #ExcelFunctions #BestExcelFormulas #excelinhindi

Audio credits :
Adventures by A Himitsu

✂✂✂ Products I Use For Making Videos:-

Check out the camera I use for my videos :

Check my Lighting gadgets :

Check my Tp-Link WiFi Router :

Check the mic I still use:

*You can assume that I will receive a commission for the above products if you purchase using the link which will support my channel. These videos are for educational purposes only.

[TechieTrickle]

Did you face this situation?
You have to get ready with a presentation and you are busy preparing your spreadsheet.
You come across datasets that looks like this :

SAP ECC ( XXX application)
SAP F&R (XY application)
Azure cloud ( ZY application)
...
...
...

1999 rows
How am I going to extract the data from with the parenthesis??

10 more minutes left before the presentation and I am still not ready with the data!!! Wish I knew excel better.

Well don't worry if you have faced such a situation in the past. Excel is smart and has solutions for most problems.

Comment below your experience. Let our community know more about this too :-).

[sonitgoswamy]

I have seen many videos but this clears my concept!!

[JP-mody]

Do you have a video that shows how to find a word that starts with a specific letter no matter which position it is in the cell? For example, if I have in each of my 10 rows a word that starts with the letter X within a random sentence. Can Excel pull that?

[kameshsharma]

Thanks sir, very helpful video. But I want to know whether we can extract more than one word. You have taught to extract one word from the middle of a line, in this video, but I want to get more than one word from a line.

[okayogut]

If the word i am trying to find is "black cotton tshirt" what formula do I need to write to find it inside a long list of sentences as "EXACT", "PHRASE" and "BROAD" match.

[bharatdarji]

Sir, We can not see letters as it requires it in big size.

[kameshsharma]

Sir, I request you to please make a formula in which I can extract two or three words from the middle of the line of a cell in Excel. I have made different formulas for both, but I am not able to form a formula by mixing them both. I am sharing both those formulas with you. You are requested to mix these two and make a formula so that I can extract two or three or four words from a line in a cell. Please Please



(To extract one word from mid of line)
=Trim(MID(SUBSTITUTE(B6, " ", REPT(" ", LEN(B6))), (C6-1)*LEN(B6)+1, LEN(B6)))

(To extract 2 or 3 word from the starting of the line)
=TRIM(LEFT(B1, FIND("~", SUBSTITUTE(B1, " ", "~", A1)&"~")))

[shivukswr]

Video iz useful but the explanation is not good..