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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to remove the leading numbers and period (prefix only in a string without effecting other numbers in the data ?
0
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))- Copy down to the end of column A.
- Copy all of column B
- Paste Special > Values (without changing the selection copied).
This will replace the formulas with their result. - Delete column A.