Hi Doug, I tried following the steps for extracting the data between delimiters using Power Query. It looks easy in your video, but when I tried it, it didn't work. The delimiters in my situation were not parentheses, but quote marks. I selected 'text between delimiters' and then typed a quote mark for the 'start delimiter,' as well as a quote mark for the 'end delimiter.' After clicking 'okay,' nothing happened. Any ideas?
I really appreciate those of you who put these types of videos out. I checked out at least 6 others videos that got out of control complicated. This was easy to follow. Thank you.
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)&"~")))
Yes you can if you don't need them; but depending on your use case like needing the original column intact then you'd want to keep it. Thanks for the sub!
Hi! congratulations for the channel, very useful !. I have a question: is there a formula that tells me that the cell of numbers with a central space "10 30 50" is included in the number cell "5 10 30 40 50" and that returns me as a result the cell "5 10 30 40 50 "? can you help me? it's important please.
It's like a keyword lookup since those numbers are acting like a string. See if these videos can help give ideas ruclips.net/video/_DnMuCw0IyQ/видео.html
Hello Doug! I need to extract two pieces of data from the same cell. This video helped me with one but I need help with the other part. Data looks like this. hotel-DIA - Worker Name - SUP7.75 I need the worker name and the SUP7.75 in separate columns. I was able to extract the SUP7.75 but still need to extract the Worker Name in a separate column. I appreciate suggestions!!
Hi Doug, I tried following the steps for extracting the data between delimiters using Power Query. It looks easy in your video, but when I tried it, it didn't work. The delimiters in my situation were not parentheses, but quote marks. I selected 'text between delimiters' and then typed a quote mark for the 'start delimiter,' as well as a quote mark for the 'end delimiter.' After clicking 'okay,' nothing happened. Any ideas?
Might want to copy/paste the quote marks if there are neutral versus curly quotes in your data.
I really appreciate those of you who put these types of videos out. I checked out at least 6 others videos that got out of control complicated. This was easy to follow. Thank you.
Hi PD, glad you liked it, thanks for commenting!
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)&"~")))
Hi Kamesh Sharma, sorry 🙁....but try a post on the mrexcel.com forum!
Is there any way to search for multiple words? and return multiple words?
Try this one ruclips.net/video/YxZ_8-vsEpE/видео.html
Can't we just use Find and Replace tool to remove those parenthesis? (It worked for me). Thank you for the video. Liked Subscribed
Yes you can if you don't need them; but depending on your use case like needing the original column intact then you'd want to keep it. Thanks for the sub!
Hi! congratulations for the channel, very useful !. I have a question: is there a formula that tells me that the cell of numbers with a central space "10 30 50" is included in the number cell "5 10 30 40 50" and that returns me as a result the cell "5 10 30 40 50 "? can you help me? it's important please.
It's like a keyword lookup since those numbers are acting like a string. See if these videos can help give ideas
ruclips.net/video/_DnMuCw0IyQ/видео.html
helped me a lot ! thanks for this Video.
Glad it helped!
nice
Thanks
Very helpful video. Thanks!
Glad it was helpful!
Hello Doug! I need to extract two pieces of data from the same cell. This video helped me with one but I need help with the other part. Data looks like this. hotel-DIA - Worker Name - SUP7.75
I need the worker name and the SUP7.75 in separate columns. I was able to extract the SUP7.75 but still need to extract the Worker Name in a separate column. I appreciate suggestions!!
maybe power query
ruclips.net/video/OjmUbC1XNwc/видео.html
Great video. V helpful. Thanks
Glad it was helpful!
❤️👍
😀
Using Flash Fill Function Would be a Easiest Than any Other method......
Flash fill would be great for this!
Thank you for sharing! It saved me some time!
Glad it helped!
Using power query things get easier. Thanks Doug.
Hi Luciano...you're welcome, glad you liked!
Thanks a lot for this - saved me a ton of hassle!
You’re welcome!
You can use substitute to replace the closing )
Hi Rick Keev, thanks for the comment!
Thank you so much
Hi John Franzen, thanks for the comment! You're welcome!
Great vedio
Hi Mohan Pal, glad you liked it, thanks for commenting!