Forum Discussion

RDKFlorida's avatar
RDKFlorida
Copper Contributor
Jul 05, 2023
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 
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 
excel
  • Mike_Y_123's avatar
    Mike_Y_123
    Jul 05, 2023
    Put this into cell B1...
    =IF(ISNUMBER(FIND("$",A1)),A1,"")

    Then copy it down as required

2 Replies

Resources