# Thread: Convert To Numbers from Text Thanks: 0 Likes: 0

1. ## Convert To Numbers from Text

Hello Message Board: I am trying to convert a small data set from text to number ( AMOUNT Column) . I have tried several methods including text to columns , Fomulas like =VALUE(TRIM(a3)), Trim, etc and I cannot get rid of the trailing spaces to the right. I need a formula solution for this. I know that I can easily resolve this in PQ but I am curious to see why I cannot change the text to numbers. Thanks in advance

Here is the file in the link below.

2. ## Re: Convert To Numbers from Text

Try

Code:
`=LEFT(I2,FIND(" ",I2,1))+0`

3. ## Re: Convert To Numbers from Text

Mr Michael! Thank you very muchhhh…. My goodness.. I have tried in all sorts of forms to get the text to number. Quick question: why the
FIND(" ",I2,1 Piece...? I guess thats the heart of the formula Thanks Again....

4. ## Re: Convert To Numbers from Text

Basically, it is saying
extract all the cells from the LEFT
Code:
`=LEFT(I2`
Until you FIND a space (" ")
and by adding a zero on the end it converts the text to a number

Hope that helps

5. ## Re: Convert To Numbers from Text

Mr Michael: Very elegant solution. I got it now. Thank you soooo much again... I will practice this several times...Have a great day...!

6. ## Re: Convert To Numbers from Text

Glad to help.....and thx for the feedback...

7. ## Re: Convert To Numbers from Text

Mr Michael.. on the contrary... thanks for your help and your quick reply. I was getting so frustared this afternoon since i started doing text to columns and it did not work. Then i tried the trim function and that did not work either..... but now, i learned your trick!