How do I remove the 1st 4 characters of a field in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
=MID(A1,5,255)
If the result is numeric for sure, you can use
=1*MID(A1,5,255)
or
=MOD(A1,100000)

Bob Umlas
Excel MVP
 
Amendment to previous response. the cells have more than 255 characters.
That's the max column width.
 
=mid(a1,4,30)

If your results are more than 30 characters long, you'll have to change
that. The maximum column width is 255 characters.
 
=mid(A1,5,255)

where A1 is your data and 255 <= the length of data in the cell.

HTH

Bruce
 
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
 
I guess you didn't try the REPLACE formula.
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
Click to expand...


--

[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.
 
By "remove", if you mean that you WANT the first four characters "only",
then use......

=LEFT(A1,4)


Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I use only 2 characters in a field in a formula 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Lower-Case Characters 2
Autofill column from data (code) in column next to it 4
Excel 4 characters alphanumeric data validation check on one excel column. 1
1st Wed, 1st Sat, 1st Sun 5
Removing Special Characters 2

Back
Top