Excel Help -- Putting dashes in product numbers

[@elliewalters4272]

This 7 year old tutorial saved me hours of work today, thank you so much!!

[@mayanknarang9607]

Thanks a ton!! I was struggling to add 16 digit number in this format and every time last digit turned to zero. This made my day. Thanks again.🤩

[@christiemp1269]

As a excel beginner, thank you so much! I've tried so many formulas and this one is the only one that worked as it said it would!

[@soulcanyon]

Thank you, Marie. Did you see that I have a full program available? Excel Essentials covers levels 1-4 with short videos, workbooks, practice files and more :) Order here: soulcanyon.com/product/excel-essentials-level-1-4-with-workbooks-and-practice-files/

[@Kai...999]

My god this is so efficient. I was using a massive and complicated formula to do the same thing, but I knew there had to be a better way.

[@soulcanyon]

Did you see that I have a full program available? Excel Essentials covers levels 1-4 with short videos, workbooks, practice files and more :) Order here: soulcanyon.com/product/excel-essentials-level-1-4-with-workbooks-and-practice-files/

[@Kalibsml]

Thank you, thank you, thank you. I used this for ID & phone numbers. You just cut my time in half.

[@shilpaparikh]

thanks for explanation, this formula worked for me as well.

[@OUD4444]

ROB.... youre the man

[@RaihanaAmir]

This was super helpful!

[@carmelawright2063]

Thank you so much! This helped a lot!

[@soulcanyon]

You're welcome! Thanks for commenting.

[@PravinAmbardekar]

Fantastic. Thank you very much.

[@myamyittzuwin634]

Thank you so much and this is very useful for me.

[@ghaider1]

Thank you so much. it really helped me.

[@cmftech3439]

How can I repeat function on different worksheet?

[@soulcanyon]

copy the function from the source worksheet and do a simple paste to the cell or cell range on the destination worksheet.

[@fakuridesne]

tq so much. help alot

[@vijey18]

Thank-you, even i was stuck with custom function for this task which was inefficient

[@dinad4509]

Can you please show how to add a - at the end of the text in a cell? For example : text to text -LLC Please

[@soulcanyon]

You just want to add a - to the end of whatever text is already in the cell? Insert a column to the right of your field that has the text values in it. In the new column right this formula: =concatenate(cell reference to text,"-"). That will fill the new column with the text from the reference column plus a dash. Then, copy the new column over the old column, but paste special value -- keyboard short cut CTRL + ALT + V, and then hit V and enter. Try that and let me know how it goes.

[@youthculture523]

Omg amazing ty so much

[@IXZAXL]

Thank you! that worked

[@mohammadafsari4686]

So nice sir , Question how can separate tags from "-" Like 1011-tw-1006a 1043-fe-1203b And so on Thank you