Notice that I put the comma within quotes because it's a text value.
All text values within a formula string need to be separated from
the formula with quotes.
So next, I will enter the substitute text in this example which is a period,
so I'll type quote, period, end quote. Next, I'll close the parentheses,
click Enter, and I'll drag down the formulas to our other cells.
Again, I'll click the Menu and fill without formatting
to ensure that our format stays the same as it was before in our table.
You might be wondering why we wouldn't just use the find and
replace function that's located in the home ribbon.
The reason is because it's always important to keep your raw data intact.
Especially if you have to do a lot of clean up.
If you have issues further down the line you may want to look back at the original
data to check.
Or you may need evidence of what you originally received.
If you start making changes and edits directly to your original data it is
extremely difficult to ensure that nothing has been changed accidentally.
Or there may be instances where you need to check if an issue was with the raw
data received or the computations done to it.
Therefore, it is a leading practice to use the reference functions that we've
learned together to clean and edit your data,
especially when you're dealing with sensitive or large data sets.
[MUSIC]