Drewgarry007
Board Regular
- Joined
- Oct 1, 2011
- Messages
- 142
Hi,
Hopefully this is an easy one for you guys. I am trying to use a wild card at the end of a formula
Excel 2010 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
The formula i'm using in "D2" is: =CONCATENATE(A2," ",TEXT(B2,"DD/MM/YYYY")&"*")
I want to be able to match the currency pair and date but nothing else after that. Is this possible?
FYI - I get a true result using this formula: =CONCATENATE(A2," ",TEXT(B2,"DD/MM/YYYY")," ","NDF") but the same will not work for cell "F4"
Thanks again for your help.
Hopefully this is an easy one for you guys. I am trying to use a wild card at the end of a formula
Excel 2010 32 bit
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
2 | USD/TWD | 19-Dec-16 | USD/TWD 19/12/2016* | USD/TWD 16/12/2016 NDF | ||
3 | USD/TWD 19/12/2016 NDF | |||||
4 | FALSE | USD/CNH 06/03/2017 |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
The formula i'm using in "D2" is: =CONCATENATE(A2," ",TEXT(B2,"DD/MM/YYYY")&"*")
I want to be able to match the currency pair and date but nothing else after that. Is this possible?
FYI - I get a true result using this formula: =CONCATENATE(A2," ",TEXT(B2,"DD/MM/YYYY")," ","NDF") but the same will not work for cell "F4"
Thanks again for your help.