View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
falcios falcios is offline
external usenet poster
 
Posts: 27
Default Rearranging text

Sample text

TEST123
$100

TEST124
$200

TEST125
$300

How can I put the dollar amount values in a separate column [column b] on
the same line as text.

Thanks