in reply to split cells
Is there any way to split the data in the cells using perl?Yes.
- Open the worksheet using your favourite Excel processing module
- Read the data from each cell
- split on whitespace
- Write the data back into the worksheet
Cheers,
Darren
In Section
Seekers of Perl Wisdom