Need help with excel

[fader]

OK there is a simple way to solve this or coplicated way (but more sofisticated).

Since i dont have access to english version of excell i wont be able to explain the hard way so the easy way is:

Create an extra column.

In extra column use function LEFT (use excell creator to proper construct the function) extract first 3 symbols
Function shuld look like ths (a1 is cell where you store information ): LEFT(a1;3)
This will extract first 3 symbols counting from left from a1 cell

Now use Find and replace to eleminate unwanted symbols (* empty spaces)

And now you should have colmn with numbers only.

Hope this helps.

---

I learned long ago, never to wrestle with a pig. You get dirty, and besides, the pig likes it.
Bernard Shaw