Forum Discussion
Solved
Excel
Need a formula in cell B that will copy the contents of cell A to Cell B if cell contains a '$' I have over 10,000 rows of data. Jul-16 06/16/16 DELTA AIR LINES ATLANTA DELT...
- Put this into cell B1...
=IF(ISNUMBER(FIND("$",A1)),A1,"")
Then copy it down as required
Put this into cell B1...
=IF(ISNUMBER(FIND("$",A1)),A1,"")
Then copy it down as required
=IF(ISNUMBER(FIND("$",A1)),A1,"")
Then copy it down as required