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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 12, 2012 at 11:35 AM
Related:
- I want to extract specific data from microsoft excell cell
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to find specific words on a page - Guide
- Microsoft excel download - Download - Spreadsheets
- Gta 5 data download for pc - Download - Action and adventure
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
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)
=MID(A1,FIND(":",A1)+1,IF(ISERROR(FIND(" ",A1,FIND(":",A1)+1)),LEN(A1) +1,FIND(" ",A1,FIND(":",A1)+1))-FIND(":",A1)-1)