Formula Please

[Steved]

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]

?????
Formula for what?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Don Guillett]

Have a look in HELP index for MID

 

[GerryK]

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

 

[Steved]

Thanks very much.

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

 

[Steved]

Thankyou very much.

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