1

How can I remove all unwanted characters from a row, and keep only the numbers that are inside the brackets, using Excel? I have a code to remove all text, but still the numbers showed outside de brackets can not be removed.

If I split in column, separating by space after remove all the text, still I cant have the rows in order, because since I cant remove all the number more unwanted columns will be created. Thank you for your help!

Example of the desired work and the data that I have.

Alice
  • 11
  • 1

1 Answers1

0

FILTERXML() may give you desired output. Try-

=TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(SUBSTITUTE(A2,"[","</s><s>"),"]","</s><s>")&"</s></t>","//s[number()=.]"))

More about FILTERXML() here by JvdV.

enter image description here

Harun24hr
  • 30,391
  • 4
  • 21
  • 36