I have output data from a program, .txt files, with multiple lines of text
with one or two numbers on each line. The number I want to isolate is
always in-between a descriptor, like x or y, then a units descriptor at the
end, like lbm^2. Here are some example lines from the output file.

I 676158.2296 lbm in^2

Axis

X 0.9881 in

Y -0.0059 in

Z -0.1538 in



The numbers do have a variable number of decimal places, like 0.9881 or
0.99, so the number of characters in each line can vary.

Is there a way to have excel isolate the numbers that have the decimal in
them?


Thanks,

Stephen R.