Home > Uncategorized > Excel Formula To Extract Numbers With Decimel Point From Cell With Alpha Numerical Content?

Excel Formula To Extract Numbers With Decimel Point From Cell With Alpha Numerical Content?

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

Uncategorized
  1. No comments yet.
Submitting Comment, Give me a second...

Leave a comment

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackbacks & Pingbacks ( 0 )
  1. No trackbacks yet.
  2. Trackbacks are currently closed.