OOo Forum,

I need a macro to allow me to "break up" a single cell in calc.

For example, if I start with,
C1 contains: "apple|     3.14      0.97        6  4"
ten what I end up with is
C1 contains "apple|"
C2 contains 3.14
C3 contains 0.97
C4 contains 6
C5 contains 4

If I could highlight multiple cells (eg C1, D1, E1, F1) and have them all 
processed, that would be a bonus!

Troy

Reply via email to