GregBrown1993
New Member
- Joined
- Feb 28, 2018
- Messages
- 2
Hello. I have my column A in Excel like this:
LT013800
LT025200
PL2011000
PL2061000
LV440200
LV604300
EE440000
EE700000
etc.
And I want my column B like this(so I want to remove two first and two last characters from column A using one formula):
0138
0252
20110
20610
4402
6043
4400
7000
etc.
Please write formula for me, I do not know anything about programming completely and I will be grateful if you help me
Greg
LT013800
LT025200
PL2011000
PL2061000
LV440200
LV604300
EE440000
EE700000
etc.
And I want my column B like this(so I want to remove two first and two last characters from column A using one formula):
0138
0252
20110
20610
4402
6043
4400
7000
etc.
Please write formula for me, I do not know anything about programming completely and I will be grateful if you help me
Greg