Excel

Question

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

mike_y_123 · Accepted Answer

Put this into cell B1...=IF(ISNUMBER(FIND("$",A1)),A1,"")Then copy it down as required

Forum Discussion