Microsoft Excel 2016 - Using the REPLACE() Function
HTML-код
- Опубликовано: 8 янв 2017
- Using the Replace() Function in Microsoft Excel 2016.
This video was created by Optimum - the IT Training Consultancy.
For more information on our Microsoft Office training courses provided in central London, UK - please click here: www.optimum.co.uk/microsoft-of...
Thank you so much! It was super easy to follow you and thanks for the last tip to copy-past values to only get the desired vales instead of having both columns.
So easy to follow and understand. Thank You!!!
THANK YOU MR TIME SAVER. I NEEDED THIS
It is really helpful. But what if we have to replace multiple character? Suppose I have replace '-' with "_" from "ABRG-2K-RFHY-IJ". How to do this in one go? Or do I have to do it one by one?
Your video was so helpful, but I have a question... the only way to "eliminate" the first Order ID is by hiding it, right? Is there another way?
nicely explain for each formula represent. thank you
Thank you
Very helpful
Thank you, Please - how do I replace the whole cell (i.e. all the text) with a number? thanks
how can we apply replace formula in a sheet??
Thank you so much.
Can we replace the value with another column?
Please zoom in while entering formulas so that we can clearly view what you do.
You then don't need that old column A anymore, right? When you delete it. All your answers turned to #REF!. How do you fix this? If you HIDE the column, you're okay. But I don't want to hide it and confuse other people who may work on the same sheet. How do you completely delete it?
Copy the new column into another column and paste with the values only option. That way you remove the replace function from the column.
thankssssss. help me so much
How to replace last characters?? Starting from last
How to relpace ?and immediately followed by two digits with space in excel
This was helpful. But how do you just change the person's name in the column Customer. Let's say you want to change "Wilman Kala" to "Jennifer" .
Thank you
Thanks Mark, you saved my ass
Common guys! really? almost 88k views with 218 likes only? :)
i want to replace all cell with different word not by same word
I also want to do it did you get thr solution
@@soorajnair7762 still there is no solution, you have to replace manually one by one
@@rakeshbaraiya9601 I have more than 300,000 rows of data. There is a GENDER column whereby MEN, M, W, WOMEN are present. I want to replace each cell having W with WOMEN and each cell having M with MEN. How do I go about it in shortcut way?
:(
Toptip: add a keyboard capture while performing your 'magic' in excel and display it on screen somewhere so that we can see how exactly you do it, even the things you don't elaborate on.
I didn’t understand the way