YO! This just made what I was suppose to be doing stupid easy LOL Like seriously, initially took me a good 30 minutes to find a replace M13 to I13 and now BOOM! Thanks!!!
Is it possible to use REGEXREPLACE with an if function? Say I have a sheet where all data is stored, (names, status, confirmation, date, location) and a separate sheets for each breakdown of each status and confirmation. As the master sheets updates, is there a way to find and replace the other sheets based on the master sheet being updated (ie move names from one particular status/confirmation sheet to another based on info in the master sheet)?
How can these be used in Google Docs? If I copy and paste my google document to an excel spreadsheet, when doing a find and replace with regular expressions (specifically one referring using "$1" to refer to the original text), it works fine. But the exact same find and replace in the google doc, the find is the same, and regular expressions work fine for the find, but the "$1" comes out literal. I.e. the original text is not used in place of "$1", but literally "$1" is used.
@@ExcelGoogleSheets no I just figured it out I use accounting format so that a automatic space is added in all my cells inorder to push the text away from the border I used to do the same in excel but there find and replace used to work fine but in Google sheets using find and replace on accounting formatted cells adds a space in the starting and at the end in every replacement
@@ExcelGoogleSheets yes it is but now I had to revert back to general format which pulled the text near the border which doesn't looks right Is there any feature like indent in excel to push the text away from the border?
How to I replace for example EVERY 2nd occurence? Eg, if I am replacing A to B, it would show: AAAAAAAA to ABABABAB What's a good way to go about this?
Someone asked me to do a SEARCH/FIND in a Range and have "whatever work/phrase" that shows up - for it to be formatted with a Strike-Through. .... That's got me puzzled, unless I script it.
Great tutorial! Thank you! Can someone please teach me how to put put a cell's text between the $'s, I tried "$1 A2 $2" and it simply prints A2 between the chunks. I also tried "$1" A2 "$2" which returned error....
i have copy and pasted 200 formula, but it went wrong in formula so final result is not visible in data sheet. Now i need to replace all 200 formula. How to do that? kindly make a video on it.
My point too. Actually, I was expecting a video about 'createTextFinder' but that wasn't the case... developers.google.com/apps-script/reference/spreadsheet/sheet#createtextfinderfindtext
Wow, you're right! And that is puzzling, really. But then you realise it's because the final ".+" means ONE OR MORE characters (but AT LEAST one) and he did it so this ONE OR MORE characters were not included in the result, so the last character was deleted.
This is the best "Find and Replace" video on the entire goddamn internet. After hours of searching I finally found my answers. THANK YOU.
:)
6 years old yet what a great video. Thank you for this awesome explanation.
Exactly what I was looking for! You don’t know how much you’ve made my work so much easier. Great info. Thank you so much! 🙏
OMG! I had to replace like 5k words and I thought I needed to be a nerd in excel but with this video I did it!!!
YO! This just made what I was suppose to be doing stupid easy LOL
Like seriously, initially took me a good 30 minutes to find a replace M13 to I13 and now BOOM!
Thanks!!!
this was the 1st out of 14 videos that actually explained the meaning behind the URLS. thank you, now i have quit crying.
You are amazing! I have been using Sheets to do some amazing projects at work and your videos have helped me move forward so many times!
thank you so much I want to use a substitute command in a google form and have it automatically copy down for the entire collum. how would I do that?
Bro you are a lifesaver
That was brilliant, thank you for making these helpful videos
What if I wanted to remove certain emails. For example If I wanted to remove all emails with info, customerservice etc how would I do that?
Thank you for this. Saving me so much time!!!
Thank man! You just save my day.
Excellent. Many thanks for this excellent tutorial that will save me so much time. You went through it nice and slow too. Bless :)
Is it possible to use REGEXREPLACE with an if function? Say I have a sheet where all data is stored, (names, status, confirmation, date, location) and a separate sheets for each breakdown of each status and confirmation. As the master sheets updates, is there a way to find and replace the other sheets based on the master sheet being updated (ie move names from one particular status/confirmation sheet to another based on info in the master sheet)?
man you are life saver
You are my savior
Awesome info. Love the videos. Keep up the great work!
How can these be used in Google Docs? If I copy and paste my google document to an excel spreadsheet, when doing a find and replace with regular expressions (specifically one referring using "$1" to refer to the original text), it works fine. But the exact same find and replace in the google doc, the find is the same, and regular expressions work fine for the find, but the "$1" comes out literal. I.e. the original text is not used in place of "$1", but literally "$1" is used.
Hi, I neet to delete all the info in a lot of cells that have wrong characters between # and #. How could you do it?
When i use find and replace function to replace text inside of cells it adds spaces in the starting and at the end of every cell
That's odd. Maybe something with your browser?
@@ExcelGoogleSheets no I just figured it out I use accounting format so that a automatic space is added in all my cells inorder to push the text away from the border
I used to do the same in excel but there find and replace used to work fine but in Google sheets using find and replace on accounting formatted cells adds a space in the starting and at the end in every replacement
Interesting.
@@ExcelGoogleSheets yes it is but now I had to revert back to general format which pulled the text near the border which doesn't looks right
Is there any feature like indent in excel to push the text away from the border?
No feature like that. If you have only numbers maybe use custom number formatting and add some spaces before the number.
Thanks a lot!
Really useful. Thanks
How to I replace for example EVERY 2nd occurence?
Eg, if I am replacing A to B, it would show:
AAAAAAAA
to
ABABABAB
What's a good way to go about this?
yes you try to set an expression like this:
find : ((A)A)*
replace with : $1B
Gorgeous!
Someone asked me to do a SEARCH/FIND in a Range and have "whatever work/phrase" that shows up - for it to be formatted with a Strike-Through. .... That's got me puzzled, unless I script it.
Can you provide some examples of text before and after?
Thank youu!
Great tutorial! Thank you!
Can someone please teach me how to put put a cell's text between the $'s, I tried "$1 A2 $2" and it simply prints A2 between the chunks. I also tried "$1" A2 "$2" which returned error....
You mean cat will result in $cat$ ?
Thanks for replying, it's fixed now. I meant, to put whatever text that's in A2, between the chunks. I think I fixed it by writing "$1" & A2 & "$2"
i have copy and pasted 200 formula, but it went wrong in formula so final result is not visible in data sheet. Now i need to replace all 200 formula. How to do that? kindly make a video on it.
As if now i replace 200 by myself
HELP ME, how to find " = " in google sheet?
Amazing
Sir can you please make this by using google script.
Or what should i use to do that..
My point too. Actually, I was expecting a video about 'createTextFinder' but that wasn't the case...
developers.google.com/apps-script/reference/spreadsheet/sheet#createtextfinderfindtext
Thanks
How to remove emojis and special characters,words of other languages from Google sheet?
18:31 Notice that after the replace the word 'Category' became 'Categor'
Wow, you're right! And that is puzzling, really.
But then you realise it's because the final ".+" means ONE OR MORE characters (but AT LEAST one) and he did it so this ONE OR MORE characters were not included in the result, so the last character was deleted.
@@Tyo_Drak Ah, yeah, I see that now.
how to repeats 15 digits using regex video please
match and replace to columns together google sheets text to columns
Woooow coool thx
thanks alot
You are god!
:)
Regex ==
🙏🏻
Do you honestly think we have 20 f’n minutes to go over this?? It doesn’t take more than 3 minutes to show how to do it.
Could you guide me how to remove or replace "/n"(enter to new line) with running google app script? I try to find and do, it didn't work at all.