Separating amount in a different column

  • Thread starter Thread starter da
  • Start date Start date
D

da

Hello
How can I separate amount into a separate column? I tried text to column but
it did not work.
Thank you
SPROUTS FARMERS MAR CLAREMONT CA 14.25
STATER BROS #045 UPLAND CA 5.04
ALBERTSONS #6555 UPLAND CA 4.69
 
Can you use a formula in another cell?

=--TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",99)),99))

=trim() returns a string (not a number). The -- stuff converts that string to a
number.
 
Back
Top