BulldogMike
asked on
Adding Spaces to a Number in Excel - Excel Macro
Hi
I have a series of numbers in column E of my spreadsheet that I want to a space after every 2 digits.
For example, I want to change 21550080140210 in cell E10 to 21 55 00 80 14 02 10 and then continue down the column (E11 to the end) until all numbers have been changed
How do I approach this situation in Excel to create a macro to do this.
Thanks for checking my question out
Mike
I have a series of numbers in column E of my spreadsheet that I want to a space after every 2 digits.
For example, I want to change 21550080140210 in cell E10 to 21 55 00 80 14 02 10 and then continue down the column (E11 to the end) until all numbers have been changed
How do I approach this situation in Excel to create a macro to do this.
Thanks for checking my question out
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Look for my next question on how to pull descriptions for these codes from Spreadsheet B into spreadsheet A where the codes reside
Thanks
Mike