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:

[TABLE="width: 157"]
<tbody>[TR]
[TD]4"2A "[/TD]
[/TR]
[TR]
[TD]10"2A "[/TD]
[/TR]
[TR]
[TD]13"2A "[/TD]
[/TR]
[TR]
[TD]3"2A "[/TD]
[/TR]
[TR]
[TD]28"2A "[/TD]
[/TR]
[TR]
[TD]6"2A "[/TD]
[/TR]
[TR]
[TD]15"2A "[/TD]
[/TR]
[TR]
[TD]11"2A "[/TD]
[/TR]
</tbody>[/TABLE]

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.