Importing Data from Table -Columns do not split [SOLVED]

[newbee391]

Greetings,

I am currently in the process of importing data from a table created in Writer (I inherit it, trying to convert to Calc) , the data is as in table as follows

Example of Data
Column Headers:
Loc Div | Item# Description | Actual System | Variance Qty Variance $ |
01 99 00000000 example data 12 23 -11 (280.00)
02 80 11111111 example data not consistent in length 14 14 100.00

Challenge importing data:

While importing the data I am able to adjust the width of the columns to separate the first two columns as follows and I get the following:
Div | Loc | Item# Description | Actual | System | Variance Qty Variance $ |

For the third column I use =Left (C2, to get Item#, and =mid(C2, 9) to separate the Item# and Description so I get this now:

Div | Loc | Item# | Description | Actual System | Variance Qty Variance $ |

Now the fun part:
The problem I'm having now is trying to extract the data from the last sections andbe able to get the following breakdown:
Actual | System | Variance Qty | Variance $ |

The width of the data varies (as from original example) and does not allow me to use the =left(), =mid(), =right() functions, plus the Quantities that are Zero show as blank and not as a numerical value.

I thank you in advance for any and all help.

[mgroenescheij]

Hi,

You need to select the whole table Table -- > Select --> Table and then convert it to text Table --> Convert ... Convert Table to text enter your delimiters into the menu.
Copy and paste Special into Calc enter your delimiters into the menu.
That's all

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[newbee391]

Thank you for great advice