1

enter image description hereenter image description hereI have one column that looks like this:

                              A

 1. Dimensions: Width: 23"Depth: 26"Height: 28"Seating Height: 14" 
 2. Dimensions: Width: 46"Depth: 26"Height: 28"Seating Height: 14" 

How can I find out only numeric data in A1 & A2?

I am using Microsoft Excel 2013, and would like to have the output look like this

       A    

 1. 23,26,28,14
 2. 46,26,28,14
3

I use free regex add-in which adds regular expression functionality in Excel, with that you get functions with regex:

=RegExReplace(RegExReplace(A1,"(\D)+",","),",?(.*[^,]),?","$1")

  • inner function converts non numbers to ,
  • outer function removes accidental leading and trailing ,s

enter image description here

  • Sorry if i have used this function in 2013 so its not work please suggest. – Sam Rathore Mar 27 '17 at 4:07
  • I'm using it with Excel 2013, also used with 2010 and works with both. Please explain how exactly it doesn't work. – Máté Juhász Mar 27 '17 at 7:36
  • i.stack.imgur.com/raHMh.png please check link – Sam Rathore Mar 27 '17 at 9:38
  • what is the list separator in your regional settings? you may need to use ; instead of , – Máté Juhász Mar 27 '17 at 9:43
  • If input of 25.0ʺW × 40.0ʺD × 36.0ʺH 28.5ʺW × 33.5ʺD × 37.0ʺH and i have need output of. 25.0,40.0,36.0 28.5,33.5,37.0 – Sam Rathore Apr 26 '17 at 4:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.