How to Add Comma After Certain Number of Characters in Excel
How to add comma after certain number of characters in excel
In this advanced excel tutorial I’ll demonstrate how you can add Comma (Or any character you want) after a certain number of characters (After nth characters) in Microsoft excel using Formula.
I am using Microsoft Excel 2019 Version for the demonstration and in this tutorial, I’ll create a formula using 4 different functions.
LEFT Function
RIGHT Function
LEN Function
CONCATENATE Function
Please subscribe to the channel for upcoming video series where I will explain different functions of Microsoft Excel
Now using all those functions, we are going to create a formula that can insert a comma after the 4th or 9th or nth character in each cell.
I’m not going to give you the formula. You’ll have to write this one on your own but I will help you understand the formula so that you can write it on your own.
Let’s say we need to put comma after 3 digits in excel. To solve this, we need to do several things.
1. We need to extract the first 3 digit and we can do that with LEFT Function. Left function extract text from the left side of your text strings and you can specify how many characters you need to
2. Now we need to add comma and we can do that with “&” as this works as Concatenate Function. Concatenate is used to join texts.
3. Now we need to join the rest of the text with our text. We an join the text by ”&” like is said before now how to add the rest of the text?
4. We can extract text from the right side using RIGHT Function and how many digits we need to extract we can specify that. Now there are two problems. How can I be sure how many characters left to the text?
5. Now we can count he characters of a text strings using LEN function. So if we apply the LEN function inside the RIGHT function and deduct 3 (number of character we already extracted with LEFT function) we can able to extract the rest of the text.
So, if we follow the instruction above and we learn how to use those functions above we can add comma in excel between names or we can even insert comma between words in excel. This is how to add comma in excel.
#InsertComma #Formula
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Смотрите видео How to Add Comma After Certain Number of Characters in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 14 Апрель 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 31,907 раз и оно понравилось 154 людям.