Hi:
I've in a spreadsheet cell (A1, A2 and A3) this string:
Alberto Fernando da Costa Paulino 200.0 132.08 0.00 7.92 0.00 0.00 7.92 140.00
Manuel Pereira 54.0 35.66 0.00 2.14 0.00 0.00 2.14 37.80
Antonio Dinis Couceiro 125.0 82.55 0.00 4.95 0.00 0.00 4.95 87.50
I need VBA code to extract to B1, B2 and B3:
Alberto Fernando da Costa Paulino
Manuel Pereira
Antonio Dinis Couceiro
To C1, C2 and C3:
200.0
54.0
125.0
And to D1, D2 and D3:
140.00
37.80
87.50
Either the alpha part of the string or the numeric one have variable length.
Someone can help me?
Thanks in advance
Bookmarks