Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Last 4 Strings from text
Both in Excel and VBScript RIGHT() will work..
Msgbox Right("123456",4) If this post helps click Yes --------------- Jacob Skaria "PumaMan" wrote: I need to extra the last 4 strings from a text that may range in length. Example: "123456789101" I need to extract only "9101" "abc1 4321" I need to extract only "4321" It will always be the last 4 of the text if that helps. I'd like to know how to do it in Excel primarily, but VBA is fine too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Extract text strings from xls cells containing outlook items | Excel Programming | |||
extract elements of strings | Excel Programming | |||
HOW TO EXTRACT STRINGS FROM CELLS | Excel Discussion (Misc queries) | |||
Extract numbers from strings | Excel Worksheet Functions |