Thread: Text to Column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ajyourpal ajyourpal is offline
external usenet poster
 
Posts: 3
Default Text to Column

Is there any way to separate Dollar amount to another column (last five
digits)?
Not all figuers have a $ sign in front of the amount.
Thank you

USPS 0545019576 LOS ANGELES CA 9.60
USPS 0545019576 LOS ANGELES CA 9.40
USPS 0545019577 LOS ANGELES CA 4.70
SHELL OIL 57442712808 UPLAND CA 16.20
VONS FUEL 10026813 UPLAND CA 26.50