![]() |
#3
|
|||
|
|||
![]()
Hello, I appreciate you taking the time to help here. It did get me thinking in another direction through. Maybe if I extract each year into its own cell, trim the first two numbers off each and put these new values back together. Might it be better to modify the formula in my original post to extract the last 2 numbers and string out the capacity to do up to 20 words. I have tried this but I don't have enough understanding of the formula to do this. Just a note: each original number will always have 4 characters and they will always be numbers. Thanks again..
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
How to assign numbers to letters and then create a formula to add them together for a rota | Mskapri | Excel | 6 | 04-01-2017 03:05 PM |
![]() |
Gef | Excel | 4 | 02-01-2015 07:14 PM |
Word not 'rounding' letters up to word in next line (parents and orphans) | Asa | Word | 4 | 09-13-2014 06:47 PM |
extract text with formula | s7y | Excel | 7 | 06-05-2013 06:18 AM |