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.
29354138 (Andrew Dillenger)
22970876 (Olaniyi O Joshua-olagunju)
27761698 (Charlie M Channington)
29126146 (Nathan L Budafucco)