How to remove Characters from fields in Excel
Вставка
- Опубліковано 26 сер 2024
- 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 easyexcelanswers@gmail.com.
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...
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.
I am glad I could be some help! I know what you mean, I have been all day trying to install some software!!
Yes VERY helpful! Hope you get your software installed :)
Hahaha
The reality behind that statement😂
Same here
Still saving lives with this 6 years later. Liked and Subscribed. Thank you for doing this.
Happy to help
Still saving lives with this 3 years later. Liked and Subscribed. Thank you for doing this.
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.
Glad it helped!
Gold! Great explanation! Concise! Thank you!
Glad it was helpful!
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!!!
Glad I could help
Just saved me about 2 hours of headache!
glad I could help
thank u...I was trying to solve this kind of issue for past half an hour.
Happy to help
This video is very useful ..... it can save you hours of hard labour
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! 👌
Glad it was helpful!
Thanks a bunch! other videos did not work for me removing a simple period, but yours did!
Happy it helped!
BEST VIDEO EVER
thanks
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!!!!!!!!!!!!
Glad I could help
Thank you very much for some useful technic
You are welcome
short and sweet, no music nonsense ! perfect
thanks
Thank you very much my problem is solved in second .👍
Great 👍
Thank you! That was easy!
Glad you liked it!
thank you that save me a lot of time ❤
Glad it helped!
Very helpful, thanks
Glad it was helpful!
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
try this b1=right(a1,7)
wow, this is superb. saved me a lot of work, thanks
Glad it helped!
thank you very much you ae the best you made my work very easy
Glad I could help!
Thanks for your good information
Welcome
Thank you!! Saved me so much time with this function!!
Great to hear!
Thanks to you 🙌🏻
It helped
Glad to hear that!
Helped a lot thanks!!!
You're welcome!
Deb you are awesome. This was so helpful! Thank you.
You are so welcome!
i honestly thought this was Phyllis talking from The Office haha
thank you for the video, great help!
Glad you liked it!
Very helpful. thanks a lot dear
My pleasure 😊
Thank you so much it really really works now 💖💖💖
No problem 😊
What an easy walkthrough! Amazing
Glad you think so!
Thanks Barb!
You are so welcome!
Many thanks:) my problem solved...
glad I could help
SO easy and quick, I appreciate you!
Glad it helped!
THANKS BARB!!!
Welcome!
Thanks.. Very helpful
Glad it helped
Your a godsend. Just saved me probably 2 hours of work. Thank you!
I glad I could help.
thank christ I find this! true youtube hero!
Happy to help
You are a Goddess...saved me so much time. Thank you!
Glad it helped!
Thank you Ma'am 🙏 it works
Most welcome 😊
Concise and to the point. Thanks a lot
You're welcome!
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! ;)
Glad it helped!
This was really helpful thank you!!
You're so welcome!
Great mam,
Thanks a lot , love u
Most welcome 😊
Thank you soooo freaking much!
You're welcome!
thank you - easy to follow, quick and to the point video. Excellent when you need to sort through data late a tnight.
Glad you liked it!
Thank you!
You're welcome!
Really helpful❤️
Glad it was helpful!
You are the best.
thanks
Just saved me two hours worth of work, thanks!!
Glad it helped!
save me a lot of time!!! glad i found this!!
Glad I could help!
Thank you for this, so helpful and to the point.
Happy to help
0:50
I love that okeeeee with abuelita accent
I am glad you like it
Thanku so much❤❤
happy to help
Thanks, exactly what I needed.
Glad it helped!
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.
Happy it helped
Thank you!!!
You're welcome!
how would you do it with two characters?
Ex: Andy Dalton*+
Legend 10/10 worked
Happy to help
Thank you so much
You're most welcome
OMG THANK YOU!!!
welcome!
Great Video Barb, Strait and to the point.
Glad you liked it!!
I am very new to excel and this was very helpful. Thank you Barb!
Thank you
You're welcome
Thank you.
Welcome!
You just saved me so much time, thank you for this great resource!!!
Happy to help!
Thank you. You are Good learner.
Very good tricks! Thank you 😍
You're so welcome!
Thank you very much!! It is very useful
THANKS A LOT
You're welcome!
Thanks 😊
Welcome 😊
wow thank you
Welcome!
Thank you for your tip, very helpful
Thanks a lot
Happy to help
Very helpful! Thank you
Glad it was helpful!
thank you
You're welcome
Wow this is awesome, thanks you very much!
You're very welcome!
thank you so muchhhhhhh, it really helpful, save lots of my time, God bless you
loves from Indonesia
Thank you, it worked perfectly!!
You're welcome!
Great direct to the point 🥰
Glad you liked it
Thanks barb @india
Welcome @ Canada
Thanks, in 1 minute you save countless minutes of menial work.
Happy to help
Very helpful. Thank you!
Glad it was helpful!
thanks alot maam
You are welcome!
U save my life
Happy to help
Thanks , very helpful 🙏
Glad it was helpful!
Very Nice Superb
Thanks 🤗
Thanks. This is very helpful
Great tip. Thank you for saving me so much extra time :)
You are so welcome!
Hello Barb , please how to remove from dash to end ?
Thanks
Welcome
hvala teta
Very Good
Thanks
This video saved my life! Lol. Thank you!
Glad it helped!
Very nice
Thanks
What square bracket are you clicking on at the end? All I can see is a pop up.
Thanks you! This really helped my team at crunch time!
Totally Awesome. Thank you
Your welcome!
Thank You! from deep heart.
Loved it! Thank you!!!!