Opposite of 'CONCATENATE'

[_Ken_]

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

[berg891832]

This would extract the first five characters:

=left(z1,5)

[Tonyson]

=left(z1,5)
=mid(z1,6,7)
=right(z1,15)

[_Ken_]

Berg891832,
That works well for the beginning characters, but what about those in the middle, or for instance only the 4th and 5th characters??
Has anybody got any ideas?

Ken

[_Ken_]

Tonyson,
Thanx mate !
Exactly what I was looking for.

Ken

[Tonyson]

you're welcome!

[indiantrix]

OR...if you had a whole column of similar data, you could use the Data>Text to Columns feature, choose fixed width columns, and then follow the instructions to separate the data into desired column widths. Cheers! /s/ Larry