If the number is always either at the end of row or in the penultimate position, then you can use the script below to extract them all and paste them into a second column. (It's much easier than it sounds, basically cut-paste, then select, click, and paste results).
- Copy-paste script into Script Editor (in Applications > Utilities)
- Select the cells with the data.
- With the cells selected, click the triangle 'run' button.
- Click once in the top cell of a new column.
- Command-v to paste.
This is the result I get here. When pasting I clicked once in B1.
SG
tell application "Numbers"
tell front document
tell active sheet
tell (first table whose selection range's class is range)
set selRng to selection range
set pasteStr to ""
repeat with aCell in selRng's cells
tell aCell
set v to aCell's value
set ww to v's words
set lw to ww's item -1
if my isNum(lw) is true then
set pasteStr to pasteStr & lw & return
else
set pasteStr to pasteStr & ww's item -2 & return
end if
end tell
end repeat
end tell
end tell
end tell
end tell
set the clipboard topasteStr
display notification "Click a Numbers cell once and command-v to paste"
--return pasteStr -- uncomment this line to debug
to isNum(aValue)
try
aValue * 1
return true
on error
return false
end try
end isNum