Remove Data Before or After a Specific Character in Excel - With or Without Formula

In this video I demonstrate how to remove text before or after a specific character such as a space, comma or dash.

Table of Contents:

00:00 - Introduction
00:28 - Find and replace method
03:21 - Flash Fill method
04:25 - REPLACE function method
------------------------

[youniqentertainment]

Now it looks very simple and I spent hours watching the other youtube videos BUT you are the real hero. Thank you, Chester :)

[besalbkercuku]

Thank you, I find what I need. No BS, not any sponsor or formula. Direct example. What we need.

[JrBrown-jbuy]

The flash fill method was easy to employ and worked like a charm. Liked and subbed. Thank you.

[BlackwingVayu]

LORD ALL MIGHTY THANK YOU SO MUCH!! EVERY SITE AND VIDEO IS SO COMPLICATED IVE BEEN HAVING AN ISSUE FOR DAYS AND THIS SOLVED IT IN LITERALLY 90 SECONDS! YOU ARE DOING GODS WORK

[IvanCortinas_ES]

Excellent tutorial Chester, as usual. Thank you.

[jay]

Thank you, simple and clearly explained as others have said, direct. This is what we would call a Guru!!

[aliall]

Thanks dear, this trick helped me save hours of work 😊

[countduckula]

Great video Chester.
I like the Replace function.

[pankajgoikar]

Thank you so much. You reduced my task. Great person. Thank you again.

[crystalporter]

OMG I've been trying to figure this out for so long

[davidchambers]

Superb - didn't know about "replace" formula - useful. Thank you!

[JoseMoreno-ifvs]

Your a legend, tutorial appreciated 🤝🏾

[conorgallagher]

Great video Chester. Exactly what I needed.

[scottaroper]

Thank you Chester....exactly the fix that I needed!

[gwenmilan]

You sir, are a life saver. Thank you!

[notrubbelac]

Thank you! Just saved me an hour at least

[oscaragudelo]

You’re the best man!!! Learned exactly what I needed to learn a minute into the video

[MrAravindh]

Thank you thank you so much, You have saved me a huge amount of time

[mohamedfarahat]

Thanks for this great video. Could you please, present a video to show that: How can delete the contents of a sheet after a specific period (say a month of the first opening date).

[thecopygal]

Hi Chester! I just found your channel as I was searching on how to remove extra spaces in Word and you had a simple answer! I have another issue I need help with. I've been asked to convert an Excel spreadsheet to a Word table. The spreadsheet has about 3100 rows and six columns with data - mostly information about the client, names, addresses, salary, etc. When I copied in into Word, everything looked fine except for the last two columns which had multiple spaces between words. When I drilled down a bit and looked at the respective column in Excel, I saw that whoever created the Excel spreadsheet at one point had the data in the cell in several columns. It looks like they merged the columns into one cell and then chose "wrap text" so it lined up correctly (ie, name on first line, address on second line, city, state, zip on next line, etc.) However, when this column was copied to a Word table, it put multiple spaces between the lines that normally would be be broken with a return. I know there's got to be a way to fix this in the Excel column and then copy to Word so there's returns instead of spaces but I don't know how. Any ideas?