ChrisRitchie
New Member
- Joined
- Nov 15, 2011
- Messages
- 47
Hi all
I would like to copy the 1st 3 letters from the left of a cell and then remove these 3 characters from that cell too.
I have used =LEFT(B3,3) to copy the characters but I don't know how to remove those 3 characters from the cell, B3.
I appreciate any guidance you could provide.
Kind regards
Chris
I would like to copy the 1st 3 letters from the left of a cell and then remove these 3 characters from that cell too.
I have used =LEFT(B3,3) to copy the characters but I don't know how to remove those 3 characters from the cell, B3.
I appreciate any guidance you could provide.
Kind regards
Chris