Hi,

Text to colums will do that with the delimiter set as ;

Mike

"Marc T" wrote:

Hi all,

I've tried to do this with a combination of search and right/left, but end
up with a 'too many arguments' problem once I try to build in error checks
etc.

What I'm trying to do is take the contents of a cell and split it into
component parts within the same sheet...

I have something like 1234;5678;9999;0000
and I want to get cells containing 1234, 5678, 9999 & 0000 seperated. The
trouble is the amount of data can vary, and I need to account for situations
with between zero ";" characters up to six of them.

Any ideas folks?

Thanks,
Marc