View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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