Separating amount in a different column
 

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

Separating amount in a different column
 

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

Separating amount in a different column
 

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

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