Separating amount in a different column
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.
da wrote:
Last part, which is amount
"Sean Timmons" wrote:
What part(s) are you trying to split?
"da" wrote:
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
--
Dave Peterson
|