shajueasow
Well-known Member
- Joined
- Oct 7, 2004
- Messages
- 1,926
Hi all,
When a file (not an Excel file) is opened in Excel, I come across an alphanumeric line like this. HH091002345020205 or HQ091002345020205. This line is in cell A1. I want it divided like this HH-091-002345-020205, where it is seperated into 4 columns as shown. HH is a ID tag, 091 a loc code, 002345 is a running number, and the rest is the date of action. How can a macro be written to do this (the macro should divide those line starting HH and delete lines starting with HQ) so that it will check till the last entry in Column A.
TIA
When a file (not an Excel file) is opened in Excel, I come across an alphanumeric line like this. HH091002345020205 or HQ091002345020205. This line is in cell A1. I want it divided like this HH-091-002345-020205, where it is seperated into 4 columns as shown. HH is a ID tag, 091 a loc code, 002345 is a running number, and the rest is the date of action. How can a macro be written to do this (the macro should divide those line starting HH and delete lines starting with HQ) so that it will check till the last entry in Column A.
TIA