Locate 7 digits after 'dell#' in one column and have it replicat
Closed
Cat
-
Updated on Sep 1, 2017 at 04:27 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 02:35 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 02:35 PM
Related:
- Locate 7 digits after 'dell#' in one column and have it replicat
- Kmspico windows 7 - Download - Other
- Minecraft java edition free download for pc windows 7 - Download - Sandbox
- Download webcam for windows 7 - Download - Other
- Minecraft bedrock edition pc download free windows 7 - Download - Sandbox
- Microsoft fix it windows 7 - Download - Cleaning and optimization
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 1, 2017 at 02:35 PM
Sep 1, 2017 at 02:35 PM
cat, Good afternoon.
Suppose:
A1 --> asdfdell#1234567asdfasd
Try to use:
B1 --> =MID(A1,SEARCH("DELL#",A1)+5,7)
B1 --> 1234567
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
A1 --> asdfdell#1234567asdfasd
Try to use:
B1 --> =MID(A1,SEARCH("DELL#",A1)+5,7)
B1 --> 1234567
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
