Extract Certain text from a cell to another column

sivvik

New Member
Joined
Dec 8, 2016
Messages
3
I want to fetch all the text starting with common name to a different cell. example data below. can you help me with the exact formula. critical

NAME VALUE

(0)CERTIFICATE 0

(0)Version 3 (0x2)

(0)Serial Number 01:00:00:00:00:01:42:4c:14:ee:18:2f:b0:51

(0)Signature Algorithm sha1WithRSAEncryption

(0)ISSUER NAME
organizationName Cybertrust Inc
commonName Cybertrust Public SureServer SV CA
(0)SUBJECT NAME
countryName GB
stateOrProvinceName London
localityName London
organizationName Standard Chartered Bank
organizationalUnitName Financial Markets
commonName fixdemo.uk.s2bx.com
(0)Valid From Nov 12 11:58:39 2013 GMT

(0)Valid Till Oct 20 10:12:57 2014 GMT

(0)Public Key Algorithm rsaEncryption

(0)RSA Public Key (2048 bit)

(0) Public-Key: (2048 bit)

(0) Modulus:

(0) 00:ca:7f:74:7a:45:69:4c:cc:6e:19:aa:26:9a:b2:

(0) e6:5f:98:cb:8e:c2:85:6a:6c:f4:53:96:b8:79:17:

(0) 05:ad:df:df:5c:74:d1:52:fd:eb:ec:f0:2c:1a:86:

(0) 0d:18:4a:85:4e:45:9c:71:66:3a:a7:ee:d0:78:c3:

(0) 19:43:9c:06:c2:6b:d6:29:79:81:3f:a9:60:fe:a1:

(0) d4:01:a1:eb:e5:18:50:8f:a9:5e:24:52:7c:fa:f1:

(0) 5a:1e:ac:3c:23:ed:4d:6e:bf:db:b3:34:79:30:df:

(0) 98:ce:55:85:e2:19:b5:a1:4e:c5:7c:d3:1a:e4:40:

(0) 1e:7e:06:74:1e:e1:63:8b:1e:99:03:c9:d7:28:2f:

(0) 90:ee:9f:8e:71:d9:47:2c:85:e5:92:43:32:c1:5e:

(0) 65:88:11:4b:7d:be:30:bc:ba:73:db:2b:e6:52:29:

(0) c4:4a:ba:96:24:2f:9d:ea:63:1b:c3:31:22:ca:4e:

(0) ad:e0:f1:26:13:bc:da:4d:13:4e:9a:c7:8a:f0:15:

(0) c3:e4:6d:2d:3b:69:45:ef:27:f0:70:8e:31:67:70:

(0) 5d:59:51:97:69:50:aa:b2:ac:86:a9:30:3f:89:49:

(0) d2:08:38:9b:6c:a3:67:54:8a:cd:b0:ae:ab:b3:d6:

(0) 3b:3d:3d:16:2f:70:8e:79:5c:8f:f8:fd:2c:2c:a9:

(0) e7:61

(0) Exponent: 65537 (0x10001)

(0)X509v3 EXTENSIONS

(0)X509v3 Authority Key Identifier keyid:04:98:60:DF:80:1B:96:49:5D:65:56:2D:A5:2C:09:24:0A:EC:DC:B9

(0)X509v3 CRL Distribution Points

(0) Full Name:

(0) URI:http://crl.omniroot.com/PublicSureServerSV.crl

(0)X509v3 Subject Key Identifier 4B:E9:2B:9F:2F:4D:33:6A:2B:3F:AF:E0:0C:D9:21:82:36:32:E4:B8

(0)X509v3 Basic Constraints CA:FALSE

(0)X509v3 Key Usage critical

(0) Digital Signature, Key Encipherment

(0)X509v3 Extended Key Usage TLS Web Server Authentication, TLS Web Client Authentication

(0)Netscape Cert Type SSL Client, SSL Server

(0)X509v3 Subject Alternative Name DNS:fixdemo.uk.s2bx.com

(0)Signature (256 octets)

(0) 7c:d8:63:33:63:9f:90:55:de:3b:7d:76:f2:c9:f8:21

(0) fe:a8:c2:42:26:32:6c:1c:10:c5:ba:21:58:1a:ab:59

(0) 2e:6f:28:3f:4d:62:e8:37:ae:a4:c4:84:bd:10:99:d8

(0) 78:5f:4b:59:e7:a5:f4:e7:7a:87:25:c3:4f:dc:4e:46

(0) da:2d:fc:6a:16:5e:0c:95:16:27:38:40:54:11:02:ff

(0) 8f:31:b1:71:8b:36:b9:74:a6:95:90:15:d1:8e:6e:c0

(0) cb:2a:ed:04:db:1c:91:f0:10:49:50:b2:c2:f0:f4:58

(0) ee:cc:cf:e9:3c:a7:23:c0:34:24:14:54:63:f1:b4:1e

(0) fd:af:70:53:7a:1d:90:e0:0c:33:af:ba:5f:b7:88:8b

(0) 9b:c6:ac:68:04:02:d3:e2:83:a8:4b:b2:63:e2:60:38

(0) 8b:56:de:d0:db:97:79:d8:f3:44:d1:2a:67:a5:36:b7

(0) 87:99:9b:7e:1f:55:56:7e:92:da:d0:0c:81:96:76:9a

(0) ee:99:4b:ad:c0:77:90:9a:cf:7e:b2:68:8f:7e:97:a0

(0) ec:5f:b5:2b:63:db:be:01:bf:1c:38:0d:72:69:16:ff

(0) 63:5b:c7:c6:13:bb:ab:87:1c:52:c9:1c:bb:5d:13:a0

(0) 1c:88:6f:70:d5:38:f5:5e:89:c8:bb:56:03:6c:9c:ed

(1)CERTIFICATE 1

(1)Version 3 (0x2)

(1)Serial Number 120010508 (0x727370c)

(1)Signature Algorithm sha1WithRSAEncryption

(1)ISSUER NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(1)SUBJECT NAME
organizationName Cybertrust Inc
commonName Cybertrust Public SureServer SV CA
(1)Valid From Sep 8 17:35:16 2010 GMT

(1)Valid Till Sep 8 17:34:08 2020 GMT

(1)Public Key Algorithm rsaEncryption

(1)RSA Public Key (2048 bit)

(1) Public-Key: (2048 bit)

(1) Modulus:

(1) 00:a3:ba:99:8d:b7:e1:cd:73:88:f9:b9:dd:de:f4:

(1) 05:f3:25:f5:3f:c5:52:1e:51:5a:3f:9a:ff:4d:84:

(1) b7:50:7f:f1:10:8a:5d:7f:64:55:1c:3b:a3:f3:ff:

(1) 97:7f:1c:4b:ed:6f:7f:e9:54:ec:97:2a:42:03:67:

(1) 7f:b9:c8:6c:a2:97:f8:40:93:24:c3:25:5e:a5:66:

(1) 8b:86:bd:d7:b9:26:22:6e:d2:66:83:b3:78:c1:7c:

(1) 58:76:11:eb:16:55:47:32:f0:b9:34:10:bd:8f:26:

(1) a2:25:68:c1:14:2b:a2:73:d6:66:3d:44:87:5c:13:

(1) 7f:58:91:62:3d:57:7f:6c:ae:42:e8:12:7e:bd:78:

(1) f1:f1:ac:5c:35:60:68:45:bc:53:73:87:11:1d:c5:

(1) 2e:fa:60:35:da:91:f9:da:f2:55:6c:bf:ca:a2:57:

(1) 5c:c8:64:bc:a9:5b:15:a0:fc:1c:f3:44:2e:bd:06:

(1) f2:68:d8:40:2d:bb:b3:61:25:92:93:25:1c:77:46:

(1) 90:bf:d0:af:b7:83:a0:3c:87:5e:a5:91:a8:ff:c1:

(1) 31:1b:b6:4b:ac:12:34:08:d5:db:ec:89:87:63:06:

(1) a7:53:f8:d5:f5:e6:66:ac:5e:84:65:46:c9:f4:3a:

(1) 25:0f:6c:cc:0f:66:b8:9a:55:a1:46:6c:fc:91:23:

(1) 5f:bd

(1) Exponent: 65537 (0x10001)

(1)X509v3 EXTENSIONS

(1)X509v3 Basic Constraints critical

(1) CA:TRUE, pathlen:0

(1)X509v3 Certificate Policies Policy: 1.3.6.1.4.1.6334.1.50

(1) CPS: http://cybertrust.omniroot.com/repository

(1)X509v3 Key Usage critical

(1) Certificate Sign, CRL Sign

(1)X509v3 Authority Key Identifier keyid:E5:9D:59:30:82:47:58:CC:AC:FA:08:54:36:86:7B:3A:B5:04:4D:F0

(1)X509v3 CRL Distribution Points

(1) Full Name:

(1) URI:http://cdp1.public-trust.com/CRL/Omniroot2025.crl

(1)X509v3 Subject Key Identifier 04:98:60:DF:80:1B:96:49:5D:65:56:2D:A5:2C:09:24:0A:EC:DC:B9

(1)Signature (256 octets)

(1) 5f:df:8b:cf:29:79:78:2b:f3:7c:f4:82:5f:79:e0:e1

(1) b3:28:bd:08:75:41:ce:8c:88:d7:0e:55:b9:02:b5:05

(1) 79:3e:bb:52:31:b3:4b:1e:b1:fe:d3:a2:21:43:d2:91

(1) d3:16:fa:6b:79:e4:8e:4d:19:ec:4c:86:68:34:52:b7

(1) 6f:c2:bd:9c:78:be:f0:6f:3f:3d:9e:9f:49:74:c4:7c

(1) 97:19:45:57:ac:6f:fa:5a:3e:3f:d3:d6:e3:2b:dc:8a

(1) f8:c8:0a:0d:6b:8c:3f:94:78:37:98:88:61:91:df:59

(1) 14:0f:09:c5:63:54:fb:f4:f6:af:97:ec:fc:63:64:43

(1) a6:bc:cc:e4:e3:1f:df:73:b0:6e:f7:b5:c8:29:9b:ae

(1) 25:52:b8:b4:72:e1:de:93:48:f1:28:9f:7e:66:3f:3f

(1) 8b:55:0f:f8:16:07:71:05:d7:65:9c:d7:1b:3c:34:e6

(1) 44:16:3a:bd:d8:60:93:83:83:0c:88:96:65:33:40:df

(1) 6a:ac:ff:fe:94:51:61:bb:89:3f:f7:ac:c4:e4:b3:47

(1) e2:fd:a2:6a:32:83:e2:7e:6f:f0:12:8e:a3:66:76:40

(1) 97:fb:11:e1:f7:73:1f:da:8b:1c:31:42:8b:9f:11:c5

(1) 49:a5:60:ed:48:2b:05:84:15:ab:2f:8a:2c:51:72:c0

(2)CERTIFICATE 2

(2)Version 3 (0x2)

(2)Serial Number 33554617 (0x20000b9)

(2)Signature Algorithm sha1WithRSAEncryption

(2)ISSUER NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(2)SUBJECT NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(2)Valid From May 12 18:46:00 2000 GMT

(2)Valid Till May 12 23:59:00 2025 GMT

(2)Public Key Algorithm rsaEncryption

(2)RSA Public Key (2048 bit)

(2) Public-Key: (2048 bit)

(2) Modulus:

(2) 00:a3:04:bb:22:ab:98:3d:57:e8:26:72:9a:b5:79:

(2) d4:29:e2:e1:e8:95:80:b1:b0:e3:5b:8e:2b:29:9a:

(2) 64:df:a1:5d:ed:b0:09:05:6d:db:28:2e:ce:62:a2:

(2) 62:fe:b4:88:da:12:eb:38:eb:21:9d:c0:41:2b:01:

(2) 52:7b:88:77:d3:1c:8f:c7:ba:b9:88:b5:6a:09:e7:

(2) 73:e8:11:40:a7:d1:cc:ca:62:8d:2d:e5:8f:0b:a6:

(2) 50:d2:a8:50:c3:28:ea:f5:ab:25:87:8a:9a:96:1c:

(2) a9:67:b8:3f:0c:d5:f7:f9:52:13:2f:c2:1b:d5:70:

(2) 70:f0:8f:c0:12:ca:06:cb:9a:e1:d9:ca:33:7a:77:

(2) d6:f8:ec:b9:f1:68:44:42:48:13:d2:c0:c2:a4:ae:

(2) 5e:60:fe:b6:a6:05:fc:b4:dd:07:59:02:d4:59:18:

(2) 98:63:f5:a5:63:e0:90:0c:7d:5d:b2:06:7a:f3:85:

(2) ea:eb:d4:03:ae:5e:84:3e:5f:ff:15:ed:69:bc:f9:

(2) 39:36:72:75:cf:77:52:4d:f3:c9:90:2c:b9:3d:e5:

(2) c9:23:53:3f:1f:24:98:21:5c:07:99:29:bd:c6:3a:

(2) ec:e7:6e:86:3a:6b:97:74:63:33:bd:68:18:31:f0:

(2) 78:8d:76:bf:fc:9e:8e:5d:2a:86:a7:4d:90:dc:27:

(2) 1a:39

(2) Exponent: 65537 (0x10001)

(2)X509v3 EXTENSIONS

(2)X509v3 Subject Key Identifier E5:9D:59:30:82:47:58:CC:AC:FA:08:54:36:86:7B:3A:B5:04:4D:F0

(2) 84:03:bd:f7:64:fd:2d:d7:30:e3:a4:10:17:eb:da:29

(2) 29:b6:79:3f:76:f6:19:13:23:b8:10:0a:f9:58:a4:d4

(2) 61:70:bd:04:61:6a:12:8a:17:d5:0a:bd:c5:bc:30:7c

(2) d6:e9:0c:25:8d:86:40:4f:ec:cc:a3:7e:38:c6:37:11

(2) 4f:ed:dd:68:31:8e:4c:d2:b3:01:74:ee:be:75:5e:07

(2) 48:1a:7f:70:ff:16:5c:84:c0:79:85:b8:05:fd:7f:be

(2) 65:11:a3:0f:c0:02:b4:f8:52:37:39:04:d5:a9:31:7a

(2) 18:bf:a0:2a:f4:12:99:f7:a3:45:82:e3:3c:5e:f5:9d

(2) 9e:b5:c8:9e:7c:2e:c8:a4:9e:4e:08:14:4b:6d:fd:70

(2) 6d:6b:1a:63:bd:64:e6:1f:b7:ce:f0:f2:9f:2e:bb:1b

(2) b7:f2:50:88:73:92:c2:e2:e3:16:8d:9a:32:02:ab:8e

(2) 18:dd:e9:10:11:ee:7e:35:ab:90:af:3e:30:94:7a:d0

(2) 33:3d:a7:65:0f:f5:fc:8e:9e:62:cf:47:44:2c:01:5d

(2) bb:1d:b5:32:d2:47:d2:38:2e:d0:fe:81:dc:32:6a:1e

(2) b5:ee:3c:d5:fc:e7:81:1d:19:c3:24:42:ea:63:39:a9#

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
I want to fetch all the text starting with common name to a different cell. example data below. can you help me with the exact formula. critical

NAME VALUE

(0)CERTIFICATE 0

(0)Version 3 (0x2)

(0)Serial Number 01:00:00:00:00:01:42:4c:14:ee:18:2f:b0:51

(0)Signature Algorithm sha1WithRSAEncryption

(0)ISSUER NAME
organizationName Cybertrust Inc
commonName Cybertrust Public SureServer SV CA
(0)SUBJECT NAME
countryName GB
stateOrProvinceName London
localityName London
organizationName Standard Chartered Bank
organizationalUnitName Financial Markets
commonName fixdemo.uk.s2bx.com
(0)Valid From Nov 12 11:58:39 2013 GMT

(0)Valid Till Oct 20 10:12:57 2014 GMT

(0)Public Key Algorithm rsaEncryption

(0)RSA Public Key (2048 bit)

(0) Public-Key: (2048 bit)

(0) Modulus:

(0) 00:ca:7f:74:7a:45:69:4c:cc:6e:19:aa:26:9a:b2:

(0) e6:5f:98:cb:8e:c2:85:6a:6c:f4:53:96:b8:79:17:

(0) 05:ad:df:df:5c:74:d1:52:fd:eb:ec:f0:2c:1a:86:

(0) 0d:18:4a:85:4e:45:9c:71:66:3a:a7:ee:d0:78:c3:

(0) 19:43:9c:06:c2:6b:d6:29:79:81:3f:a9:60:fe:a1:

(0) d4:01:a1:eb:e5:18:50:8f:a9:5e:24:52:7c:fa:f1:

(0) 5a:1e:ac:3c:23:ed:4d:6e:bf:db:b3:34:79:30:df:

(0) 98:ce:55:85:e2:19:b5:a1:4e:c5:7c:d3:1a:e4:40:

(0) 1e:7e:06:74:1e:e1:63:8b:1e:99:03:c9:d7:28:2f:

(0) 90:ee:9f:8e:71:d9:47:2c:85:e5:92:43:32:c1:5e:

(0) 65:88:11:4b:7d:be:30:bc:ba:73:db:2b:e6:52:29:

(0) c4:4a:ba:96:24:2f:9d:ea:63:1b:c3:31:22:ca:4e:

(0) ad:e0:f1:26:13:bc:da:4d:13:4e:9a:c7:8a:f0:15:

(0) c3:e4:6d:2d:3b:69:45:ef:27:f0:70:8e:31:67:70:

(0) 5d:59:51:97:69:50:aa:b2:ac:86:a9:30:3f:89:49:

(0) d2:08:38:9b:6c:a3:67:54:8a:cd:b0:ae:ab:b3:d6:

(0) 3b:3d:3d:16:2f:70:8e:79:5c:8f:f8:fd:2c:2c:a9:

(0) e7:61

(0) Exponent: 65537 (0x10001)

(0)X509v3 EXTENSIONS

(0)X509v3 Authority Key Identifier keyid:04:98:60:DF:80:1B:96:49:5D:65:56:2D:A5:2C:09:24:0A:EC:DC:B9

(0)X509v3 CRL Distribution Points

(0) Full Name:

(0) URI:http://crl.omniroot.com/PublicSureServerSV.crl

(0)X509v3 Subject Key Identifier 4B:E9:2B:9F:2F:4D:33:6A:2B:3F:AF:E0:0C:D9:21:82:36:32:E4:B8

(0)X509v3 Basic Constraints CA:FALSE

(0)X509v3 Key Usage critical

(0) Digital Signature, Key Encipherment

(0)X509v3 Extended Key Usage TLS Web Server Authentication, TLS Web Client Authentication

(0)Netscape Cert Type SSL Client, SSL Server

(0)X509v3 Subject Alternative Name DNS:fixdemo.uk.s2bx.com

(0)Signature (256 octets)

(0) 7c:d8:63:33:63:9f:90:55:de:3b:7d:76:f2:c9:f8:21

(0) fe:a8:c2:42:26:32:6c:1c:10:c5:ba:21:58:1a:ab:59

(0) 2e:6f:28:3f:4d:62:e8:37:ae:a4:c4:84:bd:10:99:d8

(0) 78:5f:4b:59:e7:a5:f4:e7:7a:87:25:c3:4f:dc:4e:46

(0) da:2d:fc:6a:16:5e:0c:95:16:27:38:40:54:11:02:ff

(0) 8f:31:b1:71:8b:36:b9:74:a6:95:90:15:d1:8e:6e:c0

(0) cb:2a:ed:04:db:1c:91:f0:10:49:50:b2:c2:f0:f4:58

(0) ee:cc:cf:e9:3c:a7:23:c0:34:24:14:54:63:f1:b4:1e

(0) fd:af:70:53:7a:1d:90:e0:0c:33:af:ba:5f:b7:88:8b

(0) 9b:c6:ac:68:04:02:d3:e2:83:a8:4b:b2:63:e2:60:38

(0) 8b:56:de:d0:db:97:79:d8:f3:44:d1:2a:67:a5:36:b7

(0) 87:99:9b:7e:1f:55:56:7e:92:da:d0:0c:81:96:76:9a

(0) ee:99:4b:ad:c0:77:90:9a:cf:7e:b2:68:8f:7e:97:a0

(0) ec:5f:b5:2b:63:db:be:01:bf:1c:38:0d:72:69:16:ff

(0) 63:5b:c7:c6:13:bb:ab:87:1c:52:c9:1c:bb:5d:13:a0

(0) 1c:88:6f:70:d5:38:f5:5e:89:c8:bb:56:03:6c:9c:ed

(1)CERTIFICATE 1

(1)Version 3 (0x2)

(1)Serial Number 120010508 (0x727370c)

(1)Signature Algorithm sha1WithRSAEncryption

(1)ISSUER NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(1)SUBJECT NAME
organizationName Cybertrust Inc
commonName Cybertrust Public SureServer SV CA
(1)Valid From Sep 8 17:35:16 2010 GMT

(1)Valid Till Sep 8 17:34:08 2020 GMT

(1)Public Key Algorithm rsaEncryption

(1)RSA Public Key (2048 bit)

(1) Public-Key: (2048 bit)

(1) Modulus:

(1) 00:a3:ba:99:8d:b7:e1:cd:73:88:f9:b9:dd:de:f4:

(1) 05:f3:25:f5:3f:c5:52:1e:51:5a:3f:9a:ff:4d:84:

(1) b7:50:7f:f1:10:8a:5d:7f:64:55:1c:3b:a3:f3:ff:

(1) 97:7f:1c:4b:ed:6f:7f:e9:54:ec:97:2a:42:03:67:

(1) 7f:b9:c8:6c:a2:97:f8:40:93:24:c3:25:5e:a5:66:

(1) 8b:86:bd:d7:b9:26:22:6e:d2:66:83:b3:78:c1:7c:

(1) 58:76:11:eb:16:55:47:32:f0:b9:34:10:bd:8f:26:

(1) a2:25:68:c1:14:2b:a2:73:d6:66:3d:44:87:5c:13:

(1) 7f:58:91:62:3d:57:7f:6c:ae:42:e8:12:7e:bd:78:

(1) f1:f1:ac:5c:35:60:68:45:bc:53:73:87:11:1d:c5:

(1) 2e:fa:60:35:da:91:f9:da:f2:55:6c:bf:ca:a2:57:

(1) 5c:c8:64:bc:a9:5b:15:a0:fc:1c:f3:44:2e:bd:06:

(1) f2:68:d8:40:2d:bb:b3:61:25:92:93:25:1c:77:46:

(1) 90:bf:d0:af:b7:83:a0:3c:87:5e:a5:91:a8:ff:c1:

(1) 31:1b:b6:4b:ac:12:34:08:d5:db:ec:89:87:63:06:

(1) a7:53:f8:d5:f5:e6:66:ac:5e:84:65:46:c9:f4:3a:

(1) 25:0f:6c:cc:0f:66:b8:9a:55:a1:46:6c:fc:91:23:

(1) 5f:bd

(1) Exponent: 65537 (0x10001)

(1)X509v3 EXTENSIONS

(1)X509v3 Basic Constraints critical

(1) CA:TRUE, pathlen:0

(1)X509v3 Certificate Policies Policy: 1.3.6.1.4.1.6334.1.50

(1) CPS: http://cybertrust.omniroot.com/repository

(1)X509v3 Key Usage critical

(1) Certificate Sign, CRL Sign

(1)X509v3 Authority Key Identifier keyid:E5:9D:59:30:82:47:58:CC:AC:FA:08:54:36:86:7B:3A:B5:04:4D:F0

(1)X509v3 CRL Distribution Points

(1) Full Name:

(1) URI:http://cdp1.public-trust.com/CRL/Omniroot2025.crl

(1)X509v3 Subject Key Identifier 04:98:60:DF:80:1B:96:49:5D:65:56:2D:A5:2C:09:24:0A:EC:DC:B9

(1)Signature (256 octets)

(1) 5f:df:8b:cf:29:79:78:2b:f3:7c:f4:82:5f:79:e0:e1

(1) b3:28:bd:08:75:41:ce:8c:88:d7:0e:55:b9:02:b5:05

(1) 79:3e:bb:52:31:b3:4b:1e:b1:fe:d3:a2:21:43:d2:91

(1) d3:16:fa:6b:79:e4:8e:4d:19:ec:4c:86:68:34:52:b7

(1) 6f:c2:bd:9c:78:be:f0:6f:3f:3d:9e:9f:49:74:c4:7c

(1) 97:19:45:57:ac:6f:fa:5a:3e:3f:d3:d6:e3:2b:dc:8a

(1) f8:c8:0a:0d:6b:8c:3f:94:78:37:98:88:61:91:df:59

(1) 14:0f:09:c5:63:54:fb:f4:f6:af:97:ec:fc:63:64:43

(1) a6:bc:cc:e4:e3:1f:df:73:b0:6e:f7:b5:c8:29:9b:ae

(1) 25:52:b8:b4:72:e1:de:93:48:f1:28:9f:7e:66:3f:3f

(1) 8b:55:0f:f8:16:07:71:05:d7:65:9c:d7:1b:3c:34:e6

(1) 44:16:3a:bd:d8:60:93:83:83:0c:88:96:65:33:40:df

(1) 6a:ac:ff:fe:94:51:61:bb:89:3f:f7:ac:c4:e4:b3:47

(1) e2:fd:a2:6a:32:83:e2:7e:6f:f0:12:8e:a3:66:76:40

(1) 97:fb:11:e1:f7:73:1f:da:8b:1c:31:42:8b:9f:11:c5

(1) 49:a5:60:ed:48:2b:05:84:15:ab:2f:8a:2c:51:72:c0

(2)CERTIFICATE 2

(2)Version 3 (0x2)

(2)Serial Number 33554617 (0x20000b9)

(2)Signature Algorithm sha1WithRSAEncryption

(2)ISSUER NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(2)SUBJECT NAME
countryName IE
organizationName Baltimore
organizationalUnitName CyberTrust
commonName Baltimore CyberTrust Root
(2)Valid From May 12 18:46:00 2000 GMT

(2)Valid Till May 12 23:59:00 2025 GMT

(2)Public Key Algorithm rsaEncryption

(2)RSA Public Key (2048 bit)

(2) Public-Key: (2048 bit)

(2) Modulus:

(2) 00:a3:04:bb:22:ab:98:3d:57:e8:26:72:9a:b5:79:

(2) d4:29:e2:e1:e8:95:80:b1:b0:e3:5b:8e:2b:29:9a:

(2) 64:df:a1:5d:ed:b0:09:05:6d:db:28:2e:ce:62:a2:

(2) 62:fe:b4:88:da:12:eb:38:eb:21:9d:c0:41:2b:01:

(2) 52:7b:88:77:d3:1c:8f:c7:ba:b9:88:b5:6a:09:e7:

(2) 73:e8:11:40:a7:d1:cc:ca:62:8d:2d:e5:8f:0b:a6:

(2) 50:d2:a8:50:c3:28:ea:f5:ab:25:87:8a:9a:96:1c:

(2) a9:67:b8:3f:0c:d5:f7:f9:52:13:2f:c2:1b:d5:70:

(2) 70:f0:8f:c0:12:ca:06:cb:9a:e1:d9:ca:33:7a:77:

(2) d6:f8:ec:b9:f1:68:44:42:48:13:d2:c0:c2:a4:ae:

(2) 5e:60:fe:b6:a6:05:fc:b4:dd:07:59:02:d4:59:18:

(2) 98:63:f5:a5:63:e0:90:0c:7d:5d:b2:06:7a:f3:85:

(2) ea:eb:d4:03:ae:5e:84:3e:5f:ff:15:ed:69:bc:f9:

(2) 39:36:72:75:cf:77:52:4d:f3:c9:90:2c:b9:3d:e5:

(2) c9:23:53:3f:1f:24:98:21:5c:07:99:29:bd:c6:3a:

(2) ec:e7:6e:86:3a:6b:97:74:63:33:bd:68:18:31:f0:

(2) 78:8d:76:bf:fc:9e:8e:5d:2a:86:a7:4d:90:dc:27:

(2) 1a:39

(2) Exponent: 65537 (0x10001)

(2)X509v3 EXTENSIONS

(2)X509v3 Subject Key Identifier E5:9D:59:30:82:47:58:CC:AC:FA:08:54:36:86:7B:3A:B5:04:4D:F0

(2) 84:03:bd:f7:64:fd:2d:d7:30:e3:a4:10:17:eb:da:29

(2) 29:b6:79:3f:76:f6:19:13:23:b8:10:0a:f9:58:a4:d4

(2) 61:70:bd:04:61:6a:12:8a:17:d5:0a:bd:c5:bc:30:7c

(2) d6:e9:0c:25:8d:86:40:4f:ec:cc:a3:7e:38:c6:37:11

(2) 4f:ed:dd:68:31:8e:4c:d2:b3:01:74:ee:be:75:5e:07

(2) 48:1a:7f:70:ff:16:5c:84:c0:79:85:b8:05:fd:7f:be

(2) 65:11:a3:0f:c0:02:b4:f8:52:37:39:04:d5:a9:31:7a

(2) 18:bf:a0:2a:f4:12:99:f7:a3:45:82:e3:3c:5e:f5:9d

(2) 9e:b5:c8:9e:7c:2e:c8:a4:9e:4e:08:14:4b:6d:fd:70

(2) 6d:6b:1a:63:bd:64:e6:1f:b7:ce:f0:f2:9f:2e:bb:1b

(2) b7:f2:50:88:73:92:c2:e2:e3:16:8d:9a:32:02:ab:8e

(2) 18:dd:e9:10:11:ee:7e:35:ab:90:af:3e:30:94:7a:d0

(2) 33:3d:a7:65:0f:f5:fc:8e:9e:62:cf:47:44:2c:01:5d

(2) bb:1d:b5:32:d2:47:d2:38:2e:d0:fe:81:dc:32:6a:1e

(2) b5:ee:3c:d5:fc:e7:81:1d:19:c3:24:42:ea:63:39:a9#

<tbody>
</tbody>

toooooooooooooo much

give us some data in one cell and what you want to extract to another cell, to estblish the principles
 

sivvik

New Member
Joined
Dec 8, 2016
Messages
3
toooooooooooooo much

give us some data in one cell and what you want to extract to another cell, to estblish the principles

Cell A1 has the below

NAME VALUE

(0)CERTIFICATE 0

(0)Version 3 (0x2)

(0)Serial Number 01:00:00:00:00:01:42:4c:14:ee:18:2f:b0:51

(0)Signature Algorithm sha1WithRSAEncryption

(0)ISSUER NAME
organizationName Cybertrust Inc
commonName Cybertrust Public SureServer SV CA
(0)SUBJECT NAME
countryName GB
stateOrProvinceName London
localityName London
organizationName Standard Chartered Bank
organizationalUnitName Financial Markets
commonName fixdemo.uk.s2bx.com
(0)Valid From Nov 12 11:58:39 2013 GMT


I want the text and words after the word commonName fetched in B2 cell
 

sivvik

New Member
Joined
Dec 8, 2016
Messages
3
toooooooooooooo much

give us some data in one cell and what you want to extract to another cell, to estblish the principles

Each Cell has lot of commonName and it needs to be retrieved to the next column.

Example

I am Indian
CommonName Go Data
IamUS
CommonName Go Excersise

All the above are in one cell

output I am asking is

commonName Go Data
commonName go Excersise should be retrieved
 

Watch MrExcel Video

Forum statistics

Threads
1,126,949
Messages
5,621,781
Members
415,856
Latest member
jimb2k

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top