Hi Gary,
NoOp wrote (17-9-2009 2:10)
On 09/15/2009 07:34 PM, jomali wrote:
Put the formula
=MID(A1;FIND(" ";A1);LEN(A1))+0
in Cell B1.
Extend down as far as your data in Column A goes.
Sort on column B
Voila!
I'm having trouble figuring that out... wouldn't be the first time :-)
Would it be OK if I emailed you the spreadsheet so that you can try with
the original?
I tried and it does work perfect. (Better at RC ?? ;-) )
Alternative:
=VALUE(MID(A1;FIND(" ";A1);LEN(A1)))
Ciao - Cor
--
Cor Nouws
- nl.OpenOffice.org marketing contact
- Community Contributor Representative in the Community Council
Gevoel niet vrij te zijn? Zie www.nieuwsteversie.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
