Microsoft Excel 2016 - Using the REPLACE() Function

Using the Replace() Function in Microsoft Excel 2016.

This video was created by Optimum - the IT Training Consultancy.

[lapenesfamily]

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.

[evelynmuir]

So easy to follow and understand. Thank You!!!

[asmeromtesfai]

THANK YOU MR TIME SAVER. I NEEDED THIS

[cinthyamorocho]

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?

[sabitatamang]

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?

[benjiwong]

nicely explain for each formula represent. thank you

[sahiladya]

Can we replace the value with another column?

[daniew]

Thank you, Please - how do I replace the whole cell (i.e. all the text) with a number? thanks

[pankajSingh-oxtk]

how can we apply replace formula in a sheet??

[naveenofficial]

How to replace last characters?? Starting from last

[KungFuMojo]

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?

[musvas]

Please zoom in while entering formulas so that we can clearly view what you do.

[vikasjha]

How to relpace ?and immediately followed by two digits with space in excel

[SantoshTiwari-rwvc]

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" .

[jierylumactao]

Common guys! really? almost 88k views with 218 likes only? :)

[sambeard]

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.

[rakeshbaraiya]

i want to replace all cell with different word not by same word