How do I parse text from one cell to another cell?
I would like to move row by row the space following the number through the closing parenthesis for each row to column B. Since each line of data is not the same length, how do you write a macro to accomplish the task? I would like to invoke the Do Until/While function if possible.
25594831 Test.xlsm (Too Tall)
29354138 (Andrew Dillenger)
22970876 (Olaniyi O Joshua-olagunju)
27761698 (Charlie M Channington)
29126146 (Nathan L Budafucco)