How to remove the leading numbers and period (prefix only in a string without effecting other numbers in the data ?

0

Hi TeachExcel, I have one question.... say if I have something like
1. gabram32@gmail.com
2.jabal2rodney@hotmail.com
3. james_r_smith@gmail.com etc. in one column
and I want it to be
gabram32@gmail
jabal2rodney@hotmail.com
james_r_smith@gmail.com
how do I accomplish that ? Thanks for any help.

Answer
Discuss

Answers

0

Presuming that your original data are in column A, insert a blank column B and enter the following formula in that column's row 2.

[B2] =TRIM(MID($A2, FIND(". ",$A2)+1,100))
  1. Copy down to the end of column A.
  2. Copy all of column B
  3. Paste Special > Values (without changing the selection copied).
    This will replace the formulas with their result.
  4. Delete column A.
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login