Cleaning Specific Data withing a range from a cell

  • Thread starter Thread starter Ziantist
  • Start date Start date
Z

Ziantist

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.
 
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
 
Back
Top