Hi,
Can you please help.
Is there a formula where I can remove the last 4 characters out of a group on number/characters.
E.g. T2102070216
All I would like is the irst part of the code T210207
David
Hi,
Can you please help.
Is there a formula where I can remove the last 4 characters out of a group on number/characters.
E.g. T2102070216
All I would like is the irst part of the code T210207
David
Re: Removing Characters out of a long string of characters via formula
Hello,
you can combine the left and len functions to remove the last four characters from a string
[COLOR="#0000FF"]=LEFT(A1,LEN(A1)-4)[/COLOR]
Re: Removing Characters out of a long string of characters via formula
Morning Pike,
Thankyou very much, that works perfectly.
I dont suppose there is a way of removing the first character away too.
kindest regards
Dave
Re: Removing Characters out of a long string of characters via formula
morning,
[COLOR="#0000CD"]=MID(A1,3,LEN(A1)-5)[/COLOR]
Re: Removing Characters out of a long string of characters via formula
Fantastic, many thanks
Re: Removing Characters out of a long string of characters via formula
glad to help
Don’t have an account yet? Register yourself now and be a part of our community!