Forum Discussion
RDKFlorida
Jul 05, 2023Copper Contributor
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 |
- Put this into cell B1...
=IF(ISNUMBER(FIND("$",A1)),A1,"")
Then copy it down as required
2 Replies
Sort By
- RDKFloridaCopper ContributorSolved issue.
- Mike_Y_123Copper ContributorPut this into cell B1...
=IF(ISNUMBER(FIND("$",A1)),A1,"")
Then copy it down as required