Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LibreOffice windows - extract numbers only from a long list of text and numbers

Hi I wonder how I can perform in LibreoOffice this extraction... using windows with Version: 4.2.2.1

I have LONG list like this...I have all in 1 cell in a spreadsheet...

24991 CIGUERA 24991 LOIS 24991 SALAMON 24991 VALBUENA DEL ROBLO 24994 BURON 24994 LIEGOS 24995 LARIO 24995 POLVOREDO 24996 ACEBEDO 24996 MARAÑA 24996 UÑA, LA

I need to extract the numbers only or delete the text...dont know if there is a better text manipulaiton software to do this or if libreoffice/open office can do it.

output should be

24991, 2499, 24994

thanks for your help

LibreOffice windows - extract numbers only from a long list of text and numbers

Hi I wonder how I can perform in LibreoOffice this extraction... using windows with Version: 4.2.2.1

I have LONG list like this...I have all in 1 cell in a spreadsheet...

24991 CIGUERA 24991 LOIS 24991 SALAMON 24991 VALBUENA DEL ROBLO 24994 BURON 24994 LIEGOS 24995 LARIO 24995 POLVOREDO 24996 ACEBEDO 24996 MARAÑA 24996 UÑA, LA

I need to extract the numbers only or delete the text...dont know if there is a better text manipulaiton software to do this or if libreoffice/open office can do it.

output should be

24991, 2499, 24994

thanks for your help