I want to extract specific data from microsoft excell cell

Closed
kormanda Posts 1 Registration date Wednesday December 12, 2012 Status Member Last seen December 12, 2012 - Dec 12, 2012 at 03:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 12, 2012 at 11:35 AM
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


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 12, 2012 at 11:35 AM
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)
0