format cell to place colon btw every 2 alphanumeric characters
we have part numbers that are 12 alphanumeric characters. They need to be
entered into a cell and the cell needs to automatically place a colon between every two. I have been able to customize the cell to do so between every two numbers or every two letters, but it will not do it when there is a mix of letters and numbers |
All times are GMT +1. The time now is 05:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com