extracting numbers from a string

[mistersteve]

Hello all, can you please help.
I require to extract all numbers left of the " character

Column A is like:

4"2A "

10"2A "

13"2A "

3"2A "

28"2A "

6"2A "

15"2A "

11"2A "

<tbody>
</tbody>

Thanks in advance


EDIT:
i should have stated the characters already extracted have 5 blanks to the left of them, they need to be ignore to allow the formula to work

 

[Joe4]

I assume that you mean the numbers to the left of the first " (as there are two " in each entry).
If that is the case, then for an entry in cell A1, try this formula:

=TRIM(LEFT(A1,FIND("""",A1)-1))

 

[mistersteve]

Perfect Joe

thank you

 

[Joe4]

You are welcome.