KyleJackMorrison
Board Regular
- Joined
- Dec 3, 2013
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello,
I have a product codes that is laid out like this:
1234-56-789-1234
Our product demand sheet requires the product numbers to be in it own cell and also without the "-".
Is there a formula or VBA code where i can convert the product number to:
A B C D E F G H I J K L M
1 2 3 4 5 6 7 8 9 1 2 3 4
Thanks in advance.
Kyle
I have a product codes that is laid out like this:
1234-56-789-1234
Our product demand sheet requires the product numbers to be in it own cell and also without the "-".
Is there a formula or VBA code where i can convert the product number to:
A B C D E F G H I J K L M
1 2 3 4 5 6 7 8 9 1 2 3 4
Thanks in advance.
Kyle