Add comma after 2 digits, rows with varying number of digits.

[ElodieHardt]

I am working on a data import for work that contains rows with varying numbers of digits in each row. However, I need each to be comma separated (every 2) to work in the import.
A few things:

- The numbers vary in every row. It could be XXX or XXXXXXXXXXXXXXXXX
- The commas need to be coming from the right so X,XX or X, XX, XX, XX, XX, XX, XX, XX, XX

If the number of digits was the same in every row this wouldn't be an issue, but because they vary, I cannot find a solution to this.

I should add I tried formatting the number as XX, XX, XX, XX in the number format screen but it does not hold. I also tried ##","##","##","##","## but that leaves extra commas if there are not enough numbers in the cell, which will not work in my import.

Any ideas?!

Thanks in advance!

[MrChulo]

Hello Elodie,

Created this as a function so that you can implement it where you want.

Please Login or Register  to view this content.

You would call the function like so:

Please Login or Register  to view this content.

Tested and works

Good luck!

[ElodieHardt]

Thank you!!

[TizianoMagno]

Hello,

Could you please upload a workbook where you demonstrate this function?

Kind regards