Good morning experts!
Users send in tickets that require a MAC address. They come in all different kinds of formats:
... you get the idea...
So we copy and paste the info from the ticket into a spreadsheet for processing and then work of the spreadsheet to do them in bulk.
In one application, we have to enter the mac in all lower case letters with no special characters. (xxxxxxxxxxxx)
Then in another application, we have to enter the MAC in all upper case letters with : as separators. (XX:XX:XX:XX:XX:XX)
So I would like to paste into column A however it is in the ticket and then have column B automatically remove any special characters and make all lower case. Then Column C would automatically make them upper case and add the : where needed.
Does anyone know a formula to make this happen?
I am using Excel 2007 (MS Office Professional)