Cleaning Specific Data withing a range from a cell
 

I have nested some Numbers into [ ], into a description column.

What i would like to do is extract the numbers between these [ ]' s

example;

[33462] 3/4" EMT ON STL 3 #12

I can not use the MID function as I also have some descriptions that look
like the following;

[ ] 3/4" CONDUIT - EMT

with no data in the [ ]'s, which i would like to produce a null value.


Please can anyone help.

Cleaning Specific Data withing a range from a cell
 

Hi

With the string in A1 try this formula:

=IF(MID(A1,2,SEARCH("]",A1,2)-2)="",0,VALUE(MID(A1,2,SEARCH("]",A1,2)-2)))

Regards,
Per

"Ziantist" skrev i meddelelsen
...
I have nested some Numbers into [ ], into a description column.

What i would like to do is extract the numbers between these [ ]' s

example;

[33462] 3/4" EMT ON STL 3 #12

I can not use the MID function as I also have some descriptions that look
like the following;

[ ] 3/4" CONDUIT - EMT

with no data in the [ ]'s, which i would like to produce a null value.


Please can anyone help.

Cleaning Specific Data withing a range from a cell
 

=IF(ISNUMBER(--MID(A1,2,1)),--MID(A1,2,FIND("]",A1)-2),"")


"Ziantist" wrote:

I have nested some Numbers into [ ], into a description column.

What i would like to do is extract the numbers between these [ ]' s

example;

[33462] 3/4" EMT ON STL 3 #12

I can not use the MID function as I also have some descriptions that look
like the following;

[ ] 3/4" CONDUIT - EMT

with no data in the [ ]'s, which i would like to produce a null value.


Please can anyone help.