Divide by 3
(I'm working with a .TXT file).
In column A, if 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 by 3? (For example:
$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).
|