MarcMermans
New Member
- Joined
- Dec 4, 2012
- Messages
- 7
Hello All,
I need some help to convert a list of 40000 items to a specific format in Excel.
I have a colum with the following data
LFO1066A
LFTF105
PTXTAA103
They need to be converted to the following format
<TBODY>
</TBODY>
Column B always a lenght of 1
Column C max lenght of 5
Column D always lenght of 4
Column E / if the last character of Column A is alfanummeric
Columm F the alfanummeric character
Can someone give me some hints to solve the problem with VBA.
Thankx in advance.
I need some help to convert a list of 40000 items to a specific format in Excel.
I have a colum with the following data
LFO1066A
LFTF105
PTXTAA103
They need to be converted to the following format
A | B | C | D | E | F |
LFO1066A | L | FO | 1066 | / | A |
LFTF105 | L | FTF | 0105 | ||
PTXTAA103 | P | TXTAA | 0103 | ||
<TBODY>
</TBODY>
Column B always a lenght of 1
Column C max lenght of 5
Column D always lenght of 4
Column E / if the last character of Column A is alfanummeric
Columm F the alfanummeric character
Can someone give me some hints to solve the problem with VBA.
Thankx in advance.
Last edited: