Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 266
Fero Avatar asked Nov 16 '11 09:11

Fero


People also ask

How do I split text by Space in Excel?

Select the text you wish to split, and then click on the Data menu > Split text to columns. Select the Space. Your text will be split into columns.


1 Answers

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.

like image 169
tohuwawohu Avatar answered Sep 27 '22 18:09

tohuwawohu