How to remove Characters from fields in Excel

How to remove Characters from fields in Excel, remove characters from the middle of cells of data. How to remove unwanted characters. Check out my templates page for free and purchased templates www.easyexcela...
Click this link to check out my one-on-one training www.calendly.co...
For more help visit my website www.easyexcelanswers.com or email me at [e-mail].
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting www.calendly.co...
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com... to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.
I am able to provide online help on your computer at a reasonable rate.
www.amazon.com...
I use a Blue condenser Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.c...
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy....
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
www.youtube.com...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
How to insert VBA code in Excel • How to insert VBA code...

[@LoSheriow]

I love you!!! Thank you!! I was about to throw my laptop across the room because I could NOT get rid of the dashes lol.

[@BarbHendersonconsulting]

I am glad I could be some help! I know what you mean, I have been all day trying to install some software!!

[@LoSheriow]

Yes VERY helpful! Hope you get your software installed :)

[@shahidilyas5088]

Hahaha

[@tylersebs3373]

The reality behind that statement😂

[@hurainfatima611]

Same here

[@alijette]

Still saving lives with this 6 years later. Liked and Subscribed. Thank you for doing this.

[@BarbHendersonconsulting]

Happy to help

[@jeremycumbie6355]

Still saving lives with this 3 years later. Liked and Subscribed. Thank you for doing this.

[@lindar6569]

THANK YOU! When I think of how many hours I've wasted going through spreadsheets with thousands of lines, just to remove the one's with dashes I want to cry.

[@BarbHendersonconsulting]

Glad it helped!

[@TheJeepinDad]

Gold! Great explanation! Concise! Thank you!

[@BarbHendersonconsulting]

Glad it was helpful!

[@pick2flip333]

Thank you very much!!! I had 1ooo plus cells to correct and I was going to pay someone to fix it. But thank God I came across this video. Hat off to you ma'am! Great video!!!

[@BarbHendersonconsulting]

Glad I could help

[@tc7584]

Just saved me about 2 hours of headache!

[@BarbHendersonconsulting]

glad I could help

[@praptinegi9365]

thank u...I was trying to solve this kind of issue for past half an hour.

[@BarbHendersonconsulting]

Happy to help

[@niranlodoni2540]

This video is very useful ..... it can save you hours of hard labour

[@erick.rodrigues86]

Barb, you have no idea of how helpful this video was!
I import financial data from the Brazilian stock market and for some reason one of the collumns uses a dot to separate decimals (the Brazilian format uses commas), so I couldn't apply my filters as Excel was seeing that collumn as text and not numbers. I tried many many workarounds from other videos, but you were spot on! Now my spreadsheet is perfect! 👌

[@BarbHendersonconsulting]

Glad it was helpful!

[@LaFamiliaLopezWi]

Thanks a bunch! other videos did not work for me removing a simple period, but yours did!

[@BarbHendersonconsulting]

Happy it helped!

[@JeetPandit108]

BEST VIDEO EVER

[@BarbHendersonconsulting]

thanks

[@hunterjumper626626]

After almost 2 hours of wanting to rip my hair out, I thought, hang on- there has to be a better way to do this.. sure enough, found your video. Wish I thought to look this up first. DUH. Exactly what I needed. THANK YOU!!!!!!!!!!!!

[@BarbHendersonconsulting]

Glad I could help

[@srrukkarnsil]

Thank you very much for some useful technic

[@BarbHendersonconsulting]

You are welcome

[@raminbarnet1]

short and sweet, no music nonsense ! perfect

[@BarbHendersonconsulting]

thanks

[@muicin]

Thank you very much my problem is solved in second .👍

[@BarbHendersonconsulting]

Great 👍

[@jdhill95]

Thank you! That was easy!

[@BarbHendersonconsulting]

Glad you liked it!

[@ibr4]

thank you that save me a lot of time ❤

[@BarbHendersonconsulting]

Glad it helped!

[@vasimgondal1622]

Very helpful, thanks

[@BarbHendersonconsulting]

Glad it was helpful!

[@ckliesh1]

Thank you for sharing. What if I want the first 4 letters/characters removed? How can I create a formula for the following: IF data in cell A1 reads BAW-TCH-TIS, how do I have cell B1 equal cell A1, minus the first 4 letters or numbers? For example cell A1 reads BAW-TCH-TIS. Cell B2 should read TCH-TIS. I have 6,000 rows of data that I must remove the first 3 letters and the dash. Any assistnace would be greatly appreciated

[@BarbHendersonconsulting]

try this b1=right(a1,7)

[@user-fu4cb5hn6l]

wow, this is superb. saved me a lot of work, thanks

[@BarbHendersonconsulting]

Glad it helped!

[@mohamedamine5308]

thank you very much you ae the best you made my work very easy

[@BarbHendersonconsulting]

Glad I could help!

[@betterdaysarecomingorconti360]

Thanks for your good information

[@BarbHendersonconsulting]

Welcome

[@MentorMel]

Thank you!! Saved me so much time with this function!!

[@BarbHendersonconsulting]

Great to hear!

[@user-qc6he3wz5b]

Thanks to you 🙌🏻
It helped

[@BarbHendersonconsulting]

Glad to hear that!

[@jaszielmarieoliva1638]

Helped a lot thanks!!!

[@BarbHendersonconsulting]

You're welcome!

[@zumbafuego]

Deb you are awesome. This was so helpful! Thank you.

[@BarbHendersonconsulting]

You are so welcome!

[@pacmanh22]

i honestly thought this was Phyllis talking from The Office haha
thank you for the video, great help!

[@BarbHendersonconsulting]

Glad you liked it!

[@olanikeadunola3436]

Very helpful. thanks a lot dear

[@BarbHendersonconsulting]

My pleasure 😊

[@thenomiworld9039]

Thank you so much it really really works now 💖💖💖

[@BarbHendersonconsulting]

No problem 😊

[@mrCetus]

What an easy walkthrough! Amazing

[@BarbHendersonconsulting]

Glad you think so!

[@rhysnoott7173]

Thanks Barb!

[@BarbHendersonconsulting]

You are so welcome!

[@meerabkhan6475]

Many thanks:) my problem solved...

[@BarbHendersonconsulting]

glad I could help

[@jo-mamas]

SO easy and quick, I appreciate you!

[@BarbHendersonconsulting]

Glad it helped!

[@szmcheffey]

THANKS BARB!!!

[@BarbHendersonconsulting]

Welcome!

[@INGHUSSAMKAMEL]

Thanks.. Very helpful

[@BarbHendersonconsulting]

Glad it helped

[@nerdsofthecorn1216]

Your a godsend. Just saved me probably 2 hours of work. Thank you!

[@BarbHendersonconsulting]

I glad I could help.

[@Loucestsoire]

thank christ I find this! true youtube hero!

[@BarbHendersonconsulting]

Happy to help

[@calabamian]

You are a Goddess...saved me so much time. Thank you!

[@BarbHendersonconsulting]

Glad it helped!

[@user-tw6uc8yt9m]

Thank you Ma'am 🙏 it works

[@BarbHendersonconsulting]

Most welcome 😊

[@deepakpizar5830]

Concise and to the point. Thanks a lot

[@BarbHendersonconsulting]

You're welcome!

[@josecandelier7979]

This was extremely helpful!! I watched a few others but this one was simple and to the point! Great job! Saved me a couple of hours headache! ;)

[@BarbHendersonconsulting]

Glad it helped!

[@kamiliaelgammal7656]

This was really helpful thank you!!

[@BarbHendersonconsulting]

You're so welcome!

[@user-ny5ew4is1d]

Great mam,
Thanks a lot , love u

[@BarbHendersonconsulting]

Most welcome 😊

[@BEluxeHolisticSpa]

Thank you soooo freaking much!

[@BarbHendersonconsulting]

You're welcome!

[@musu20]

thank you - easy to follow, quick and to the point video. Excellent when you need to sort through data late a tnight.

[@BarbHendersonconsulting]

Glad you liked it!

[@TrapBunnt]

Thank you!

[@BarbHendersonconsulting]

You're welcome!

[@tinak9591]

Really helpful❤️

[@BarbHendersonconsulting]

Glad it was helpful!

[@matthewl7778]

You are the best.

[@BarbHendersonconsulting]

thanks

[@camperlanders1226]

Just saved me two hours worth of work, thanks!!

[@BarbHendersonconsulting]

Glad it helped!

[@tnamnatmnaw7544]

save me a lot of time!!! glad i found this!!

[@BarbHendersonconsulting]

Glad I could help!

[@TanniaGalindo]

Thank you for this, so helpful and to the point.

[@BarbHendersonconsulting]

Happy to help

[@miliba]

0:50
I love that okeeeee with abuelita accent

[@BarbHendersonconsulting]

I am glad you like it

[@byadav2649]

Thanku so much❤❤

[@BarbHendersonconsulting]

happy to help

[@DanielFlores-jc3vk]

Thanks, exactly what I needed.

[@BarbHendersonconsulting]

Glad it helped!

[@vinaykumar5243]

Thank you so much Barb madam. this is very simple, but i break my head for 3 days to do this work on this. Small poison will kill big body.

[@BarbHendersonconsulting]

Happy it helped

[@user-ht1hf1bn3l]

Thank you!!!

[@BarbHendersonconsulting]

You're welcome!

[@ub3r133tn355]

how would you do it with two characters?
Ex: Andy Dalton*+

[@inflationistransitory]

Legend 10/10 worked

[@BarbHendersonconsulting]

Happy to help

[@sunilverma4831]

Thank you so much

[@BarbHendersonconsulting]

You're most welcome

[@coach_yo]

OMG THANK YOU!!!

[@BarbHendersonconsulting]

welcome!

[@brianrosenstein7290]

Great Video Barb, Strait and to the point.

[@BarbHendersonconsulting]

Glad you liked it!!

[@williamhenderson922]

I am very new to excel and this was very helpful. Thank you Barb!

[@immanuelgonsalvez9616]

Thank you

[@BarbHendersonconsulting]

You're welcome

[@mahmoudfaouzichaoubi5855]

Thank you.

[@BarbHendersonconsulting]

Welcome!

[@airefcotrainingservicegrou9142]

You just saved me so much time, thank you for this great resource!!!

[@BarbHendersonconsulting]

Happy to help!

[@Mamununic]

Thank you. You are Good learner.

[@jazreenahisham146]

Very good tricks! Thank you 😍

[@BarbHendersonconsulting]

You're so welcome!

[@cnchong6873]

Thank you very much!! It is very useful

[@usamafida2952]

THANKS A LOT

[@BarbHendersonconsulting]

You're welcome!

[@ramyachappidi9693]

Thanks 😊

[@BarbHendersonconsulting]

Welcome 😊

[@johanesalberto6136]

wow thank you

[@BarbHendersonconsulting]

Welcome!

[@vivekn6530]

Thank you for your tip, very helpful

[@agaazaggarwal]

Thanks a lot

[@BarbHendersonconsulting]

Happy to help

[@michellebartolo804]

Very helpful! Thank you

[@BarbHendersonconsulting]

Glad it was helpful!

[@user-gr9vs3ws3u]

thank you

[@BarbHendersonconsulting]

You're welcome

[@average_joe3325]

Wow this is awesome, thanks you very much!

[@BarbHendersonconsulting]

You're very welcome!

[@rositaoktaviani9156]

thank you so muchhhhhhh, it really helpful, save lots of my time, God bless you
loves from Indonesia

[@Trey_D_2023]

Thank you, it worked perfectly!!

[@BarbHendersonconsulting]

You're welcome!

[@omarr7825]

Great direct to the point 🥰

[@BarbHendersonconsulting]

Glad you liked it

[@dhaivattrivedi2898]

Thanks barb @india

[@BarbHendersonconsulting]

Welcome @ Canada

[@joaquinzannchez3184]

Thanks, in 1 minute you save countless minutes of menial work.

[@BarbHendersonconsulting]

Happy to help

[@st3435]

Very helpful. Thank you!

[@BarbHendersonconsulting]

Glad it was helpful!

[@user-pz2dm5jc1i]

thanks alot maam

[@BarbHendersonconsulting]

You are welcome!

[@user-gi7fk8ve2s]

U save my life

[@BarbHendersonconsulting]

Happy to help

[@elfakirsabir1424]

Thanks , very helpful 🙏

[@BarbHendersonconsulting]

Glad it was helpful!

[@gaganthakur482]

Very Nice Superb

[@BarbHendersonconsulting]

Thanks 🤗

[@sivabalan_m]

Thanks. This is very helpful

[@zaykofmusic]

Great tip. Thank you for saving me so much extra time :)

[@BarbHendersonconsulting]

You are so welcome!

[@chmalak]

Hello Barb , please how to remove from dash to end ?

[@harishharish-yz5gq]

Thanks

[@BarbHendersonconsulting]

Welcome

[@andrejsem8355]

hvala teta

[@official360news]

Very Good

[@BarbHendersonconsulting]

Thanks

[@DLITINTHEHOUSE]

This video saved my life! Lol. Thank you!

[@BarbHendersonconsulting]

Glad it helped!

[@shanidi5961]

Very nice

[@BarbHendersonconsulting]

Thanks

[@rstocks1]

What square bracket are you clicking on at the end? All I can see is a pop up.

[@nicolestone3047]

Thanks you! This really helped my team at crunch time!

[@MrRodzilla01]

Totally Awesome. Thank you

[@BarbHendersonconsulting]

Your welcome!

[@ranasingh8694]

Thank You! from deep heart.

[@l.d.9903]

Loved it! Thank you!!!!