|
|
#4
04-06-2019, 08:19 AM
|
|||
|
|||
If you can live with an xlsm file,
how about a User Defined Function (UDF) ? Code:
Public Function LastTwo(Orig As String) As String
Dim i As Long, arr
arr = Split(Orig, " ")
For i = LBound(arr) To UBound(arr)
LastTwo = Trim(LastTwo & " " & Right(arr(i), 2))
Next i
End Function
|
|
|
Similar Threads
|
||||
| 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 |
 I'm looking for a formula to extract all the text before the last name in a cell
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode