I have a tricky problem, need to extract the following examples
(of course would be easier if architect had done this originally grr !!)
Original Widths and height are within the same cell e.g:-
1585W x 2100H
572.5W x 750H
1022.5W x 2100H
Need to extract into separate Width and Height columns e.g
W & H
So I can apply the varying width and height frame tolerances
I could do it manually of course but run the risk of mistyping and supplying lots of windows the wrong size ….. any ideas as I am struggling !
Andy
Excel Formula To Extract Numbers With Decimel Point From Cell With Alpha Numerical Content?
July 30th, 2010
Comments ( 0 )
Feed for this Entry Leave a comment