put 2 formulas in one cell?

[mike12345]

Hi,

I have some information that is 12 characters long. I want to drop off the first 2 characters of each cell and also drop off the last 4 as well. I have the below formual WS2541259992

=RIGHT(D48, LEN(D48)-4)&" "&LEFT(D48, LEN(D48)-4)

But when i run that formula for the below cell

WS2541259992

It returns the below

2541259992 WS254125

Basically I want it to return 254125 all in once without having to do two formulas in two different cells. Can anyone tell me how to do this? Thanks

[tom1977]

try maybe this

Please Login or Register  to view this content.

[brokenbiscuits]

=mid(d48,3,len(d48)-6)

[MarvinP]

Hi mike12345,

Try =MID(A1,3,6) in B1 with your 12 characters in A1.

[mike12345]

The MID formula did it. Thanks everyone