I want to extract specific data from microsoft excell cell

[Closed]
Report
Posts
1
Registration date
Wednesday December 12, 2012
Status
Member
Last seen
December 12, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i want to extract the following details into another collumn (bold ) from data in collumn B1 into C1. The information i want begins with 3 digits with a '/' then other digits follow.
M / AS308 - :308/65588 POUN
S33 / 33 - :133/01504 TR
NI101 - :101/915635 T
N101 - :101/915635

thank you


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
try this

=MID(A1,FIND(":",A1)+1,IF(ISERROR(FIND(" ",A1,FIND(":",A1)+1)),LEN(A1) +1,FIND(" ",A1,FIND(":",A1)+1))-FIND(":",A1)-1)