Excel Extract fixed length amount from cell

Question

Excel Extract fixed length amount form cell

Imported data to one column (A) Need to Extract the Amount from Start Position 20 and Field Length 11

Solar Mike · Accepted Answer · 2018-12-27 12:45:09Z

4

Try mid(), something like

=mid(A1,20,11)

If the source is in cell A1.

Not tested as I am on a smartphone...

answered Dec 27, 2018 at 12:45

Solar Mike

8,4255 gold badges23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1