Finding and extracting text in a cell, splitting into smaller chun
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
|