Hello guys,
i am stuck in this, did few searches but not able to find solution to this simple problem.
I want to extract 25 characters from Right of a column.
My data starts from, let's say B2 till end (End(xlDown)) .
how can i achieve this using simple VBA code.
My data got Unicode characters + symbols in it, i believe that doesn't make any difference.
So basically i want Right (B2,25) but using VBA for whole column till the last record.
Sample table:-
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:244px;"></colgroup><tbody>
</tbody>
End result will be:-
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:244px;"></colgroup><tbody>
</tbody>
Thanking you in advance.
i am stuck in this, did few searches but not able to find solution to this simple problem.
I want to extract 25 characters from Right of a column.
My data starts from, let's say B2 till end (End(xlDown)) .
how can i achieve this using simple VBA code.
My data got Unicode characters + symbols in it, i believe that doesn't make any difference.
So basically i want Right (B2,25) but using VBA for whole column till the last record.
Sample table:-
A | |
1 | Description |
2 | PEF Invoice No. 61724556 Ref. CPS |
3 | PEF Invoice No. 61738222 Ref. CPS |
4 | PEF Invoice No. 61798350 Ref. CPS |
5 | PEF Invoice No. 61804695 Ref. CPS |
6 | PEF Invoice No. 61882858 Ref. CPS |
7 | PEF Invoice No. 61781054 Ref. CPS |
8 | PEF Invoice No. 65047248 Ref. CPS |
9 | PEF Invoice No. 67007403 Ref. CPS |
10 | PEF Invoice No. 61909416 Ref. CPS |
11 | PEF Invoice No. 61873772 Ref. CPS |
12 | PEF Invoice No. 61748818 Ref. CPS |
13 | PEF Invoice No. 61763096 Ref. CPS |
14 | PEF Invoice No. 61760588 Ref. CPS |
15 | PEF Invoice No. 61886842 Ref. CPS |
16 | PEF Invoice No. 61887899 Ref. CPS |
17 | PEF Invoice No. 61890392 Ref. CPS |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:244px;"></colgroup><tbody>
</tbody>
End result will be:-
A | |
1 | Description |
2 | ice No. 61724556 Ref. CPS |
3 | ice No. 61738222 Ref. CPS |
4 | ice No. 61798350 Ref. CPS |
5 | ice No. 61804695 Ref. CPS |
6 | ice No. 61882858 Ref. CPS |
7 | ice No. 61781054 Ref. CPS |
8 | ice No. 65047248 Ref. CPS |
9 | ice No. 67007403 Ref. CPS |
10 | ice No. 61909416 Ref. CPS |
11 | ice No. 61873772 Ref. CPS |
12 | ice No. 61748818 Ref. CPS |
13 | ice No. 61763096 Ref. CPS |
14 | ice No. 61760588 Ref. CPS |
15 | ice No. 61886842 Ref. CPS |
16 | ice No. 61887899 Ref. CPS |
17 | ice No. 61890392 Ref. CPS |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:244px;"></colgroup><tbody>
</tbody>
Thanking you in advance.