Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extracting data to the right of a set character
I would like to know if there is a way to isolate the characters to
the right of a set of characters in a string. I know the basics on how to use the LEN, MID, RIGHT and LEFT functions but the problem I have is that the character is a full stop and for some of the data, the full stop occurs more than just once, otherwise it would be quite simple. For instance a string could be as follows: - yyy.yyyy.yyyyyyy.yy.y.yyy.xxx where I need to capture the xxx and the xxx could be between 2 and 5 characters long. I have tried all sorts of ways with modified code from postings on the Group but to no avail. Help much appreciated. Mark. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting characters before or after a specific character | Excel Worksheet Functions | |||
Extracting data | Excel Worksheet Functions | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
Extracting Data | Excel Discussion (Misc queries) |