You can use Data, Text to Columns;
Fixed Length
Click behind each of your characters;
Done.

"al007" wrote in message
oups.com...
What code do I need to split Id Numbers & characters in separate cells?
eg
V080779382799E
how can I have V in a separate cell, 0 in cell next to it, 8 in next
cell to the right and so on

thxs