How to add letters to numbers that appear in sequence in Excel
how to add letters in excel, how to add alphabets in excel, How to add characters in Excel.
Check out my online courses
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
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
You're a life saver! Thanks!
very Informative, thanks, how to insert the alphabet in the beginning of the number instead of at the end
You have literally saved my life with this video and renewed my faith in humanity in 1 fell swoop. If I were the Queen, I would knight you.
I had figured out the "IF' function part but to nest the "Char(code)" in it was pure genius.
Please keep doing what you are doing. I have a feeling I won't be the last person who needs you!
THANK YOU SO MUCH FOR THE FORMULA!
It is blurr cant see
how to add a letter when i put number in same cell
Hi Barb, Can you help me with adding numbers in a code.. thanks
a.a a.a.0000
b.b b.b.0000
b.b b.b.0001
b.b b.b.0002
b.b b.b.0003
b.b b.b.0004
b.b b.b.0005
b.b b.b.0006
b.b b.b.0007
c.c c.c.0000
d.d d.d.0000
d.d d.d.0001
d.d d.d.0002
d.d d.d.0003
d.d d.d.0004
Thank you, it helped me a lot. There is only one issue for me, after we get to letter "z" I need the formula to continue with "aa" then continue with "ab". Cam you help me with that
YOU ARE MY LIFE SAVER, THANK YOUUU
You are Superb
Thanks for this
when I put the formula, all the digits show the same character that I put between " "……….!!!! help me please!
I was looking for fixing it for a long time and finally found it here. It tremendously saves my time which I had been putting with a great frustration. May You & Your Family Be Always Blessed.
I have a question. I am trying to create a invoice document for my company. For each customer I want to have separate invoice sequence. Example customer 1 I want the invoice number to be " C1234" For Customer 2 "B1234" ect.. I am trying to make the document as fool proof as possible. I currently have a document where the only invoice # I put in is the starting invoice number. The next invoice number id generated with this formula. =IF([@[Job '# ]]>1,B16+1,""). This does not work once I added in the letter. I also have a problem with then ending invoice number. =MAX(Table13[Invoice '#]) also give me an error. Any ideas how to fix this?