trim first two and last two characters

egris52788

Board Regular
Joined
Mar 6, 2003
Messages
114
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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
If it's always a 7-digit code you want "trimmed", then try

=MID(A1,3,3) where A1 houses the code.
 
Upvote 0
5 identical solutions...is that a record? :cool:

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),"")
 
Upvote 0

Forum statistics

Threads
1,217,755
Messages
6,138,421
Members
450,136
Latest member
Tabako1960

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top