Wow! In all the years I’ve been listening to “how to” teaching videos regarding text manipulation, I have NEVER heard anything so simply and expertly explained as this example. You included so many breakdowns of the entire formula that made a tremendous difference in understanding how these multiple function (imbedded) formulas work. And I learned that the end of the formula goes first and works it’s way back to the first formula, which in and of itself is a tremendous help. You’ve made a indefinite subscriber out of me. With sincere thanks.

@lydiagenereux8650

2 жыл бұрын

yes I 100% agree with you. This video is worth gold.

THERE ARE LOADS OF VIDEO on this topic and i watched more than 5, and clearly, you are the one explained it the best! Thanks for break it down and validate it on a granular level.

I have watched many other videos regrading to extract data/spilt text/data, you are the best one I think to explain soooooooo clearly!!

This tutorial was quite helpful, I enjoyed watching it and practising along as you really did put effort to explain the magic "why" in Excel. I watched many tutorials on this topic, but here I got really what searched for simple explanation. Thank you.

Excellent! The multi-separation formulas are brilliant - thanks for that!

@TeachExcel

3 жыл бұрын

You are very welcome Mr. Lord! Glad you like it :)

Finally the explanation I was looking for. Not the correct whole formula, but the way of thinking. I wanted the text from the right of the dot and left before last space. (translate google) AE12= 115. Text and multiple variable spaces continued with 15.0 km Outcome: Text and multiple variable spaces continue with = TRIM (MID (AE12; FIND ("."; AE12) +2; FIND ("~"; SUBSTITUTE (AE12, ""; "~"; LEN (AE12) -LEN (SUBSTITUTE (AE12, ""; "")) - 1)) - (FIND ("."; AE12) +2))) Thanks

I saw a lot of videos for this issue but i can tell this is the easiest and found what I wanted bcus of this video thank you so much❤

I have seen many videos so I really appreciate all whoever try to make other's life easier but I found you very much helpful. Great explanation! Well done my friend!

Thanks, well explained and without the distracting music etc. Well played 👏🏻

Excellent explanation with good examples. I’m saving this. Thank you!

Thanks for explaining this in English logically!

@TeachExcel

3 жыл бұрын

You're very welcome! I'm glad you think so!)

Thanks, you make it easy as you divided the long formula into pieces.

@TeachExcel

6 жыл бұрын

You're welcome! I'm glad that helped; I wasn't sure how easy it would be to follow as that last formula is pretty crazy.

Thanks, this tutorial is very helpful. I've struggled for a long time to find the appropriate code that will do a specific task in my VBA project. Although, I did not use directly the command "Find" because it is unacceptable to VBA. I used "Instr" instead. What helped me solved my issue is the IDEA you have presented!!! THANK YOU VERY MUCH for your shared information. I already subscribed and liked your post.

Very very useful and interesting tutorial. Extremely well explained. Big thanks!

@TeachExcel

6 жыл бұрын

You're welcome! Glad it helped :)

Awesome. This video helped me so much.

Great Job! Thank you so much!

Excellent video... Thanks!

Very well explained. Thank you

you should deserve more subscribers

I have really liked it. Thank You!

Stunning Video!!!

@TeachExcel

6 жыл бұрын

Thanks :)

Great work, thank you

Amazing tutorial

thank you very much for this great video

@TeachExcel

6 жыл бұрын

You're welcome!

perfect video

Thanks a lot

Brilliant content! Thanks a lot :-)

@TeachExcel

3 жыл бұрын

Thanks Marco :) You're very welcome!

Genius, thanks a lot

@TeachExcel

3 жыл бұрын

You're welcome! :)

situation: 1.- Each week I Get list in Excel to update in a Data Base (not excel), I use paste and copy 2.- a lot of times, the list has about 7 names inside(They are Variable), I need to separate all of them 3. It would be nice to do it, by formula (sight) The best way for me do to it : 1.-Text to column, separate by space 2.-Automate everything using macros What do you think Thank You You are the best in explaining !

that's great. thank you. what if we dont know how many delimiters we do not know (for instance in a1 we have 10, in a2 we have 15 delimiters) what we know is we want to get the text after the 7th delimeter from the end. for 2 days I am trying to get it but could not achive. can you advise? thanks again

THANKS ALOT

Hello, do you have a video that explains how to get the "C" on A6 using the formula?

Dude do you have a video on using if function to return a number from a letter. So A=1 B=2 C=3 and so on. I want to enter a word and have excel automatically calculate the value of the word? Thanks

thanks bro

Hi, could please tell how i can get everything after the second slash for example (19000-4444-55555--5050-B01889-) ?

مرسی

how would I change the formula to extract everything to the LEFT of the BAR/LINE that I substituted my spaces for? I tried to simply replace RIGHT with Left but It only returned the first name and not the first and last name that I need. please help!! :)

Hey TeachExcel, I modified one of your formulas to display everything before the first comma. (In my case the text is separated by commas). Below is my formula, but some of since some my fields don't have a comma, how would I edit this formula to display the original cell value if a comma isn't found? =IFERROR(LEFT(D1,FIND(",",D1)-1),"")

@TeachExcel

3 жыл бұрын

Just encase it in an IF statement that checks for that first. If you ask on our forum and provide some sample values it will be easier to give you better help, including code. www.teachexcel.com/talk/microsoft-office?src=yt_comment

Hello, Can we do like AB-B=A in excel ?

Cool😍😍

can you please tell me how we canFind 80-70percent similar sentences from excel.

How can you extract multiple occurrences? For example, I am trying to extract all occurrences of the word "Scale"? In this example, Methods: Cross-sectional descriptive survey of 447 US RNs using five reliable and validated measures of presenteeism: Stanford Presenteeism Scale (SPS), Job-Stress-Related Presenteesim Scale (JSRPS), Healthcare Productivity Scale (HPS), Nurses Work Functioning Questionnaire (NWFQ), and Health and Work Questionnaire (HWQ). The survey was evaluated using descriptive, exploratory, and confirmatory factor analysis.

WoW

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)&"~")))

Well the last formula: How can this work: The last function "Substitute" has one argument less than it supposed to? It did not work when I tried te run it; the message keeps coming saying the formula misses an argument.

Not able to register in your teachexcel and not able to download the materials

@TeachExcel

2 жыл бұрын

Hi Ken, not sure what the issue is, if you send me a message via the Contact page on TeachExcel.com, I can better troubleshoot it.

what about dates ? What extracting a date eg 29-08-20. just extract the entire date

@TeachExcel

3 жыл бұрын

Hi david, just ask in our forum and provide a sample value or spreadsheet and it is MUCH easier to help - I can usually not respond to comments on older videos due to the quantity of them. For this question, provide a more specific example of how you want to extract it and if the value is just text that looks like a date or an actual date. How the date is stored will determine how to extract what you need. Forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment

When I press F9 it takes me to a windows menu