Excel tip to remove or replace text without hitting delete

In this Excel tip, we'll show you a quick way to remove and replace text in a spreadsheet. This tip is handy if you need to make small changes to a text column or row, or if you just want to quickly replace one string of text with another.
If you're ever in a situation where you need to quickly remove or replace text in a spreadsheet, this tip is a great way to get the job done. It's easy to use and can save you some time and hassle!
#exceltips #exceltricks #excel

[@misterwill3625]

Thanks for showing how to do this useful tip 👏🏾

[@XecuteTheVision]

You’re welcome!

[@joshuaduggan3099]

Space bar and Astris to find and replace, great !

[@Voyeur21890]

I love you. Thank you so much!

[@XecuteTheVision]

Thanks!

[@Jchriswalker71]

Or you can do text to columns and use the delimiter of (space) then skip on the trailing columns in the preview.

[@XecuteTheVision]

Good tip!

[@AnilKumar-wm6wc]

Great

[@outlwilebonokwane1844]

Okay now how to remove both at the same time

[@Rice0987]

Ok, but Ctrl+H😊

[@XecuteTheVision]

Yes!

[@Rice0987]

@@XecuteTheVision 👦

[@vakulakandadai]

Ctrl H