trim first two and last two characters

[egris52788]

is there a formula that will trim the last two and first two characters of a 7 digit code in one sweep:

BEASW60 trimmed to ASW in the next cell.

 

[barry houdini]

If there are always 7 characters try

=MID(A1,3,3)

 

[Smitty]

Here's one way:

=MID(A1,3,3)

HTH,

Smitty

 

[Adrae]

Try this: =MID(A2,3,3) where A2 is your 7-digit code.

 

[VoG]

=MID(A1,3,3)

 

[NBVC]

If it's always a 7-digit code you want "trimmed", then try

=MID(A1,3,3) where A1 houses the code.

 

[barry houdini]

5 identical solutions...is that a record?

just for a bit of variety......if you want to exclude the first 2 and last 2 characters whatever the string length

=IF(LEN(A1)>3,MID(A1,3,LEN(A1)-4),"")

 

[Scott Huish]

and another way to do that:

=MID(A1,3,MAX(LEN(A1)-4,0))