How do I extract the numerical value of '325.00' to next column
If your data is in A1, then one way:
=MID(A1,FIND("'",A1)+1,(FIND("'",A1,2)-1))
If the number of digits is the same for all the numbers, then you could use:
=MID(A1,2,8)
Another way:
=MID(A1,2,(LEN(A1)-2))
--
"Pathung" wrote in message
...
Another software exported a list of values in the form of: '325.000',
complete with the apostrophies. How do I extract just the number itself to
the next column over?
|