In the example shown the $ is the first character.
=IF(MID(A1,1,1)="$",MID(A1,2,FIND(" ",A1)-2)/3,"")
if the $ is the second charcter use
=IF(MID(A1,2,1)="$",MID(A1,3,FIND(" ",A1)-3)/3,"")
--
GARY Wrote:
(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).
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=540474