Re: Covert strings to numbers



On 08/17/2013 10:13 PM, Lumaja wrote:
I get this figures in different cells as strings they can be converted to
numbers without the spaces.

786 879
3 825 647
4 612 526

How to convert them

This should do it:
  =value(substitute(A1," ",""))

If not, please clarify the question.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]