![]() |
|
|
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
Thanks. Works great.
|
|
|
|
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 |
repel Macro vba help is needed for interactive powerpoint.
|
Mrs Blobby | PowerPoint | 1 | 04-16-2014 10:58 PM |
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 |
Callout macro needed - Help please
|
Peter Denly | Word VBA | 19 | 07-20-2011 03:30 AM |