How to split a single word separated by space form single column into two columns

openoffice-calc
Fero picture Fero · Nov 16, 2011 · Viewed 24.5k times · Source

I am having the following records in column A

Column A

4.0K 0000000.png
4.0K 0004.png
32K 00(1).gif
16K 001.gif

My need is to split the size and name of the image in two different columns. That is

Column A    Column B

4.0K        0000000.png
4.0K        0004.png
32K         00(1).gif
16K         001.gif

How can I do this using Openoffice Calc.Version is 2.3?

Answer

tohuwawohu picture tohuwawohu · Nov 16, 2011

Beginning with OOo 2.4, you could use the "text to columns" functionality to achieve this. There's a nice tutorial with screenshots how to apply it. If upgrading isn't a viable option for you, there are some other methods described (mainly using the csv import options).

EDIT: The blog post i've linked to points to some macros for splitting text on multiple columns. This would be an option for OOo 2.3 and prior.

Related questions

How to quote a quote with the CONCATENATE function in OOCalc

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in cell B1 I want to do: =CONCATENATE("\"",A1,"\"") OOCalc does not like this, or without the escaping backslash. Does anyone …

Read More
How to add number of days to a date, consider only business days (i.e. ignore weekends)?

I'm trying to create a formula to calculate the n-th Business Date (only Monday to Friday are business days). For simplicity's sake, holidays are not important; only weekends should be ignored. For example: +------------------------------------------------------------------ | A B C +------------------------------------------------------------------ 1 | Starting Date …

Read More
Join two spreadsheets on a common column in Excel or OpenOffice

I have two CSV files with a common column and I want to "Join" the tables together on the common column. For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does not …

Read More