Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 03-18-2015, 02:28 PM
Snakehips Snakehips is offline ***help*** macro needed Windows 8 ***help*** macro needed 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Needed to bold specific lines and Macro to turn into CSV anewteacher Word VBA 1 05-28-2014 03:59 PM
***help*** macro needed repel Macro vba help is needed for interactive powerpoint. Mrs Blobby PowerPoint 1 04-16-2014 10:58 PM
***help*** macro needed I need help with macro...code needed for automatic sorting chefmate Excel Programming 1 08-26-2012 01:04 AM
Check box macro help needed Aflac Word 4 03-24-2012 07:11 PM
***help*** macro needed Callout macro needed - Help please Peter Denly Word VBA 19 07-20-2011 03:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft