How parse Numbers cell into two cells

You can add two adjacent columns, then use TEXTBEFORE and TEXTAFTER something like this:

In C1, filled down:

=TEXTBEFORE(B2," ")*1

In D1, filled down:

=TEXTAFTER(B2," ")*1

Use ; in the formulas instead of , if your region uses , as the decimal separator.

This assumes there is a space separating the numbers of share and price. If it's something else then put that between the " " in the formulas instead.

The *1 coerces the text to a number.

You can then "remove" the formulas in the added columns by selecting them, command-c to copy, Edit > Paste Formula Results. Then delete the original column if you want.

SG

SG

You could use TEXTBEFORE and TEXTAFTER for the value in cell G7 like this:

In column L on row 7:

=TEXTBEFORE(G7," shares")*1

You should insert the blank character before shares!

In column M on row 7:

=TEXTAFTER(G7,"@ ")*1

You should insert the blank character after @!

Paul.