Numbers app formula on iPhone

> My spreadsheet “objects” are all alphanumeric - application, user name, and ID, separated by spaces.

That's easy then.

Space delimiting is pretty easy.

Assuming Column A contains your 'objects', and you just want them delimited by space:

A2="Application username 12345"

B2=> TEXTBEFORE(A2," ")

C2=> TEXTBETWEEN(A2," "," ",1,1)

D2=> TEXTAFTER(A2," ",2)

This will break the source text into three distinct columns.

Probably not without an example, no.

There are about 20 gazillion ways that "3 objects of text and numbers" could be interpreted, with bazenty million ways to slice and dice that depending on the complexity and consistency of the data.

For example:

"Mary had a little lamb. It weighed 10 pounds"

meets the criteria if you consider "Mary had a little lamb. It weighed" as being the first 'text object'; 10 being the number, and " pounds" being the third object.

On a simpler example:

"1 White Blanket"

also fits the description, assuming that 1 is the quantity, "White" is the adjective, and "Blanket" is the object.

Both are possible to parse, but will require different approaches.

Ultimately you're likely to end up with some combination of TEXTBEFORE(), TEXTBETWEEN() and TEXTAFTER() as the basic text splitting functions, but maybe REGEX.EXTRACT if it's more complicated. Knowing the data we're working with (even obfuscated/fake sample data that just shows the format) will make this much easier.