Separate last word?

Discuss the spreadsheet application

Separate last word?

Postby dawidek990 » Thu Jan 10, 2019 6:36 pm

Hello, I have a question, is it possible to do something that when broken into columns will separate only last word? from last space?
or some formula for this?
separates only 29,7X59,7

greetings ;]
OpenOffice 4.1.6 Windows 10
Posts: 15
Joined: Thu Dec 13, 2018 10:27 am

Re: Separate last word?

Postby Lupp » Thu Jan 10, 2019 7:11 pm

Text to Columns can only do that if the last separator is unique.
Assuming your
Code: Select all   Expand viewCollapse view
is placed in A1, the formula
Code: Select all   Expand viewCollapse view
=MID(A1; SEARCH("[^ ]*$"; A1);65535)
should return what you want if the option to use regular expressions with the respecive functions is enabled. Regard the space behind the circonflex in "[^ ]*$".

By the way: You will never get happy with these compounds. Split them once and for all.
Currently you are working with "data" that are none in a strict sense, at leas not in a sense workable with spreadsheets, and alo not the database way.
The items, let me call them products, obviously have a property concerning an impression of the surface we might call color. In most cases this property is represented by a name in the second position - but sometimes there is another word of unclear role (and the coloris shifted to the right). Is it an apposition to the primary name? Is it placed for a property not always applicable? What is it? Then there are a few products not qualified by any name but having the color in the first place. Then ... It's simply a mess. Calc has limited abilities to process data. To process a mess with a computer you need "Artificial Intelligence" if such a thing exists and is superior to natural intelligence. Conceding that someone must have messed up things that way, however, we cannot feel sure that natural intelligence exists.
Last edited by Lupp on Thu Jan 10, 2019 7:14 pm, edited 1 time in total.
On Windows 10: LibreOffice 6.1 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
Let's create a powerful UFO: United Free Office!
Lupp from München
User avatar
Posts: 2312
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Separate last word?

Postby dawidek990 » Sat Jan 12, 2019 11:46 pm

is working.... but what can I do to separate one or two initial words?
OpenOffice 4.1.6 Windows 10
Posts: 15
Joined: Thu Dec 13, 2018 10:27 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 51 guests