Excel

[RDKFlorida]

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
DELTA AIR LINES
From: To: Carrier: Class:
PALM BEACH INTERNA ATLANTA HARTSFIELD DL P
PHOENIX SKY HARBOR DL P
N/A YY 00
N/A YY 00
Ticket Number: 00623471464361 Date of Departure: 06/21
Passenger Name: KIRK/ROGER D
Document Type: PASSENGER TICKET
$350.10
06/16/16 DELTA AIR LINES
ATLANTA
DELTA AIR LINES
From: To: Carrier: Class:
PHOENIX SKY HARBOR ATLANTA HARTSFIELD DL P
PALM BEACH INTERNA DL P
N/A YY 00
N/A YY 00
Ticket Number: 00623478192783 Date of Departure: 06/27
Passenger Name: KIRK/ROGER D
Document Type: PASSENGER TICKET
$400.10

[#2 · Accepted solution]

Put this into cell B1...
=IF(ISNUMBER(FIND("$",A1)),A1,"")

Then copy it down as required

[#3]

Solved issue.