Formula Please

Steved · Nov 16, 2004

Hello from Steved

1. 38469. Tepee Warrior (12) 4g b

May I have a formula for the above

to leave Tepee Warrior

Thankyou

Niek Otten · Nov 16, 2004

?????
Formula for what?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Don Guillett · Nov 16, 2004

Have a look in HELP index for MID

GerryK · Nov 16, 2004

=MID(A1,FIND(CHAR(32),A1)+8,13)

Steved · Nov 16, 2004

Thanks very much.

-----Original Message-----
=MID(A1,FIND(CHAR(32),A1)+8,13)
.

Steved · Nov 16, 2004

Thankyou very much.

-----Original Message-----
=MID(A1,FIND(CHAR(32),A1)+8,13)
.