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

Amazing thank you

Thank you sir

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

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?

Thank you! Just saved me an hour at least

Is there a way to use the * technique as a function?

THANK YOU

thankzzz...💚💚

Google sheets version for all three anyone?

You sir, are a life saver. Thank you!

Your a legend, tutorial appreciated 🤝🏾

THANKS ,

LORD ALL F**** 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

Thanks 👍

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

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

Damn sweet

How do I replace '2.6.18-164.11.1.el5 on Oracle Enterprise Linux release 5.9 (Carthage)' with just '2.6.18-164.11.1.el5' the REPLACE formula is not working for this? Appreciate your help

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

Suppose I have a data like-: ram 1.0 jass, suresh 2.0 city.
Now I want that the first name become dlt by the help of ctrl h.
Pls help

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

Is there any way to delete text before AND after two different characters?

How do you replace strings after first letters of names and surnames?

Great video Chester. Exactly what I needed.

How could I implement this into a vba macro? I’m trying to remove a dash and everything after it at first when running the macro.

Amazing Video!

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

Thank you very much! 8:3 ( +1)

Thank you so much, you are the best😘

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

Really helpful, you are the best.

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

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

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

the best tutorial. thank you.

Very simple to follow

Hi Chester. Great tips! One other method is with SUBSTITUTE, TRIM and REPT along with LEFT and RIGHT. Here are my formulas against your data:
=TRIM(LEFT(SUBSTITUTE(C3," ",REPT(" ",LEN(C3))),LEN(C3)))
=TRIM(RIGHT(SUBSTITUTE(F3," ",REPT(" ",LEN(F3))),LEN(F3)))
=TRIM(RIGHT(SUBSTITUTE(I3," - ",REPT(" ",LEN(I3))),LEN(I3)))
Just one more way to get there. Thanks for sharing :)) Thumbs up!!

up and until this morning I didn't know that Chester Tugwell existed. Prior to this point I thought I used to be pretty good with excel.

But despite 20 years experience, using power pivot, sql and a heap of functions and formula's, I can say that compared to Chester I am a mere ant. my knowledge of excel is a spec of dust compared to the planet sized storage of excel knowledge and skills that Chester has.

As I scanned through your video's I was utterly bedazzled by how much I don't know.

Not to mention your training, how you speak, your nusances, it all comes together in a package that makes you smoother than a 100 year old cognac. I hate excel courses. The teachers usually use example material that is utterly irrelevant and unhelpful, whilst the pace is so slow, boring and ultimately like pulling nails.

Great video Chester.
I like the Replace function.

Very intelligent

Excellent tutorial Chester, as usual. Thank you.

Can you put a space before any text in a cell
?