View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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?