Hi,
If I have something like this in say cell Z1
0001234smith00x23435600abc
Is there any way that I can put the first 5 characters in cell A1 the next 7 in B1 the next 4 in C1 .....etc
What I am trying to do is the opposite of the CONCATENATE function.
Ken
If I have something like this in say cell Z1
0001234smith00x23435600abc
Is there any way that I can put the first 5 characters in cell A1 the next 7 in B1 the next 4 in C1 .....etc
What I am trying to do is the opposite of the CONCATENATE function.
Ken