I need my users to enter delimited data in a cell, and be able to
split this data in another workbook, to ease printing and searching.
The data does not have a set format. As a workaround I have set a
range of columns that the user enter the data in individual cells
manually, but that hurts the user's readability while entering and
editing the data.

On Jul 2, 1:10 pm, Ron Rosenfeld wrote:
On Sun, 01 Jul 2007 23:26:54 -0700, atledreier wrote:
I am aware of the 'Text to columns' wizard. I was hoping to automate
this, though. Thanks anyway. :o)

- Atle

What would an "automated" process look like, to you?
--ron