How to Remove Space before numbers in Excel

[@Edulap]

Visit our Portal for Joining Free Microsoft Excel Course
www.edulap.net/

[@Edulap]

Visit our Portal for Joining Free Microsoft Excel Course
www.edulap.net/

[@zohurulislam7628]

Trillions of thanks to you sir for teaching us such a reasonable and necessary facet.

[@Edulap]

Watch our latest Video
How to Copy Value from the Status Bar
ua-cam.com/video/fEDcWkPrybs/v-deo.html

[@sitaratanakornpakin]

I have tried so many different methods, and only this one works! Thanks a lot!

[@nhinhonnhonnhi]

thank you for sharing this tip. It just helped me to save ton of time.

[@bgopinath7055]

Was trying to do this from yesterday trim or clean or find & replace nothing got worked. Finally found your video. Thank you so much for doing this.. 👍

[@johnnyh9452]

You are the GOAT. Thank you for this perfect explanation.

[@careersrits4950]

Tons and Tons of Thanks for this, My Team and me were trying to sort this almost from couple of days, today am so happy for this found a easy solution,

[@petermutai6707]

I has saved me 2 hours and possibles errors... thank to you saana.

[@AB_channel]

Thank you so much for the formulas, I am searching for this everytime. Now i got it.

[@canzoe]

Thanks a lot. You just earned a subscriber.
My only feedback is please do not use loud music. I had to mute just to concentrate on the steps :)

[@RA-rh5lb]

This formula takes the space but doesnot convert from text to numbers. For that, you need to add *1. Please correct me here. I had this issue recently and learned this way.

[@saileeparab70]

You just saved my life as well as my time.
It worked like a magic for me. I have been searching solution for this problem since a long time. Keep it up man.

[@johnstones1853]

Thanks so much! This formula was the only one that worked for me. This works for spaces after text too everybody.

[@mohammedileyas5409]

Thank you so much 😀...I have struggling to remove those spaces separately... This will be so much helpful 👍🏻

[@RA-rh5lb]

I have another issue with dates which is in text format. I tried to remove the space using this function however it doesnot convert to numbers.. what should i do

[@subhashthejus]

Thank you so much for this great video. Highly useful and most people do not know how to do this. A million thanks.

[@dudehere1981]

Thank you! quick and to the point tutorial. You saved me a good hour.

[@anotherxeo1377]

This solved my issue, where Chat GTP was failing, HUZZAH for humans!!! :D Thank you! I liked the music, I felt better about myself.

[@priyamalok47]

Oh i no longer think this is coincidence, my every query has a solution on your channel

[@mishabb4837]

Thanks...... We can use =trim.........

[@asifasyed230]

Thank you so much. I was searching exactly the same.❤

[@rere439]

This video is really saving my bottom. Thank you so much!! 😭😭

[@saurabhmanutd]

It was too much needed! Thanks a lot!

[@WaseemAkram-su7vi]

I lost hope until I've came across this facet 🎉

[@MyBabyGaana]

nobody was showing correct way for this. you did, thanks a lot

[@anikettamgadge7984]

Nice ......worked for me.....

[@blackmagicwomanrj2857]

It was driving me crazy and noone could help. Thank you so much 😁

[@CideeTV]

nice..very helpfull tutorial

[@moodybuddies]

superb helpful. You saved my time

[@ROHITKUMAR-rf7iz]

Thank you.... Its really help me

[@PriyaDharshini-hb7yj]

If this has double space in front means what should do it removes the signal space

[@AB_channel]

Thank you, you cleared my problem

[@gunasekar4098]

Really this website give more new ideas

[@atulkamble8726]

This trick is a life saver. ❤

[@guruprasadbm1987]

Hi, Can we use Trim formula instead of Substitute & Char formula

[@amershareef9953]

Thanks alot man, fater so many videos this was helpful. Thanks

[@anoopvasudevan509]

Thank you. That was very helpful and easy.

[@vinothkumar5842]

Really nice. its very helpful and thanks a lot

[@maharaja8685]

Thanks bro u do really a great job ...❤️❤️❤️❤️❤️

[@mohammedfarhan1464]

Thank you so much, it really works

[@putrisalsabila8496]

Finally, it works, thanks alot

[@sheenamolina9223]

Thank yoouuuuuuuuuuu. This is the solution I'm looking for!

[@kdawoud2011]

It is very helpful, Thanks a lot

[@sonalravindu3922]

can you please explain how you took the 160 number for char? Im not clear on that

[@subhashthejus]

Yes I too had the same question

[@starlzhun]

Finally get it! Thank you!!!

[@ford2219]

Thanks a lot man! Really really helpful. Saved me hours of work!

[@Himanshu260923]

Thanks you very Much
Much needed.

[@SathishYT9]

But those number are storing as character how to convert as number, we can't use above data in formulas for fourther

[@ajaykdiwedi]

Helpful, thank you for the video

[@chrismacena4758]

i included in your formula *1 "times one" to avoid the extra step.

[@sskarmakar]

Words will not be enough to bade thank you...

[@sivabalanmoorthy]

Thank you so much... Sure it saves lot of time.

[@linamarcela1263]

awesome!! new follower :)

[@dkbloodlust]

You are a lifesaver! Thanks a lot :)

[@cres-annmondragon4357]

It works. Thank so much 😊

[@Sangeeta_g1313]

Why do we need to select no 160

[@Silentloler436]

I was surprized to see that replacing space with "" with Ctrl+F didn't work for this, but it actually didn't. I'm still confused why it didn't work though :)

[@aryaandas345]

It's really work but I don't know why we are putting 160???

[@ashishshinde4301]

Thanks. This is excellent.!

[@khansaqib89]

Thank you so much......

[@rainredfox]

Yea the problem is i cannot sum after that, it keeps to 0 result

[@apni_likht7368]

char(160) means???

[@manickavasagams3158]

Thank you very helpful

[@Edulap]

Glad it helped

[@ASIMKHAN-xb1ql]

I tried many times but still not working for me

[@missmec2801]

Thanks. Got this

[@ManojSingh-vo5ii]

Works...Thanks a lot..

[@sanjeevi5561]

Thank you man

[@rickyliejaya5174]

billions of thank youu

[@basheer9868]

Thank you ❤

[@arshadaafaqd8636]

THANK YOU!!

[@ssri5704]

how to remove "=--" front of some numbers (some cell) in excel

[@ssri5704]

how to remove "=--" front some numbers in excel

[@FinShred]

It works, thanks.

[@lalitratnani5972]

Very useful

[@rajeshwarir9655]

Thank You

[@sallysjg7091]

Helpful

[@karthik-kf8rn]

TQ soo much ❤

[@malchand62]

Speechless 🤣🤣. Charan khaa h aapke.

[@RAJESH64362]

Thank u Thank u so much

[@aburayhan9779]

Great

[@rajatchoudhary4339]

thanks a lot

[@Edulap]

You are most welcome

[@ghimireofficial1191]

thanks

[@jesudass5604]

Thank you SO MUCH - It was really helpful 🙂

[@mercharris5266]

Didn’t work. Don’t know wtf char(160) means

[@craigviegas9913]

why 160?

[@marycatherinellorente7997]

thank you so muchhh!

[@donysahjan7438]

Thanksss

[@Warden033]

Useless when I have multiple columns in a giant data file

[@healthcure555]

change the thumbnail. it doesnt reflect the actual content. thanks for the video

[@VijayPawar-sz6gq]

🙏

[@JohnCarter-fe2he]

✌️✌️✌️❤️❤️❤️✌️✌️❤️✌️❤️✌️❤️✌️❤️

[@Dev_Bisht_]

Thank you ❤ it is very helpful

[@tasilama7005]

Thanks a lot....

[@jovana2018]

Thank you so much ❤

[@Edulap]

You're welcome 😊

[@dheerajthakur8272]

Thankyou so much bro

[@Abdul28041]

Helpful

[@Reazulislam-ux1zq]

thanks

[@Edulap]

Thanks

[@chandankumar-lf6bs]

Thank you