Previous Topic Next Topic

I want to extract specific data from microsoft excell cell

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Dec 2012 à 11:35
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)

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses