How to put spaces in your data in Excel. Format your data with spaces for easier reading.
Check out my online courses
For more help visit my website or email me at easyexcelanswers@gmail.com.
Become an Affiliate and earn 25% on Course Sales
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*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.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thank you so much for watching my video. If you have any suggestions for other topics for videos please leave them in the comments below.
Perfect! Exactly what I needed!!!
Wonderful
It made my day!
What if removing space how??
I want to that in the same cell & that too in spreadsheet not in excel. Is there any way
Thank you so much, this was exactly what I was looking for!
I want to add + on the left, when i do that it dissappears
I wanted to give a space exactly six texts from right in a cell and want the complete cell information, can you help me on this? Because I need to apply it for n number of cells which having last six digit of pincode clubbed to the state code and I need to give a space after sixth digit from right.
how to remove space
Quality stuff. Thank you
Mam, I have a phrase in D12 "howareyou
" and I want to see the space the between those words and applied the formula =LEFT(D12,3)&" "&LEFT(D12,3)&" "&RIGHT(D12,3) in D13 but getting the output as "how how you
" instead of how are you. Please provide the correct formula for the same.
thank you so much
how about if 3 words Name for (Example JohnBryanSuarez) how to put space between BryanSuarez ?????? HELP ME PLEASE
Thank you for the video. How would I add multiple spaces EG: BK2004567 = BK 200 4567
Any tips for adding a second space further along in the text? So two single spaces at separate points.
Thank you ma'am. This is EXACTLY what I needed!
I'm not great with excel but what I experienced was that instead of putting spaces after certain characters the data was returned in the cell I selected next to the one I wanted to change. So the word 'aah' for example would give me a'a' with =left(A2,2)
thanks for your help.
Thanks
thanks………
Thank you for this video Barb!