sink size extract

[makinmomb]

I want to pull out the sink size

Sample of how the first will look like formula there for drag down

[samba_ravi]

see the attached file

[makinmomb]

Thanks typing out 100 sinks would be sheer time waste

[samba_ravi]

thanks for your feedback and adding reputation

[FlameRetired]

Another way non-array.

=IF(ISNUMBER(--RIGHT(TRIM(B3),1)),TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(LOWER(B3))," x","x"),"x ","x"),"lux","")," ",REPT(" ",256)),256)),"")