Thread: Divide by 3
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY
 
Posts: n/a
Default Divide by 3

I'm working with a .TXT file.

In column A, when the second character in the cell is an $, for
example:

$369.09 xxxxx
$4,200.24 xxxx
$38.67 xxxxx
$296,169.45 xxxxx
$13.68 xxxxx

is there a way to divide the amounts (after the $) by 3 so the cell
contains:

$123.03 xxxxx
$1,400.08 xxxx
$12.89 xxxxx
$98,169.45 xxxxx
$4.56 xxxxx

(NOTE: If the second character in the row is NOT a $, leave the row as
is).