Thread: [Solved] ***help*** macro needed
View Single Post
 
Old 03-18-2015, 02:28 PM
Snakehips Snakehips is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

For example.......
Assuming your original text is in column A starting row 2....
In B2 type the formula. =RIGHT(A2,LEN(A2)-7) And then drag it down as far as you need. If you then need to convert the results to 'hard ' values........ Copy the column B and Paste Special. >>>. Values
Reply With Quote