Dear Forum,
I have a problem with an Excel file where MID or LEFT don't work or maybe I am not using it right
in D I have
<tbody>
</tbody>
etc now I need a column lets name it Z where it would show only the part "A48662.***" where the * can change from 001 to 999 i don't need anything from before or behind that's why LEFT or MID don't work for me
any ideas?
I have a problem with an Excel file where MID or LEFT don't work or maybe I am not using it right
in D I have
A48662.401.01.65.112 |
445460.A48662.603.01.65.200 |
<tbody>
</tbody>
etc now I need a column lets name it Z where it would show only the part "A48662.***" where the * can change from 001 to 999 i don't need anything from before or behind that's why LEFT or MID don't work for me
any ideas?