Locate 7 digits after 'dell#' in one column and have it replicat [Closed]

Report
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
Hi
I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.

1 reply

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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