I guess you didn't try the REPLACE formula.

Rob wrote:
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,"")





--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.