Thread
:
How do I remove the 1st 4 characters of a field in Excel?
View Single Post
#
7
Rob
Posts: n/a
If A1 contains text THEREFORE YOU and the formula in B2 is
=MID(A1,5,LEN(A1)-4) then EFORE YOU is returned.
HTH Rob
"Aladin Akyurek" wrote in message
...
MFreeman wrote:
How do I remove the 1st 4 characters of a field in Excel?
=REPLACE(A2,1,4,"")
Reply With Quote