anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
I have about 150,000 rows of data. What I am looking to do is to pull out the currency to the cell next to it.
The data is formatted like below: Please help. Thanks again!
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<tbody>
</tbody>
The data is formatted like below: Please help. Thanks again!
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
Data |
---|
$70,645.00 |
$144,840.00 |
$205,000.00 |
Different funded ($43,685); previously funded by x in y |
$60,000.00 |
Paid till 4/17/19 [$172,800, 3 years] |
$40,194 [Paid to 9/30/19] |
<tbody>
</tbody>