Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just got hit with a hot request and am looking for commands/script
that will search the text in a cell, find the last occurance of a repeating character and then delete the rest of the data in the cell from that point to the end. Here is a sample of the data I have to work with: xxxx-xxx-xx-xxx-xxxxxxx I want to scan to the last '-' in the cell and then delete the '-' along with the 7 'x' characters. Any help to leverage something that already exists versus writing a script would be appreciated. Regards, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Character Search a cell | Excel Worksheet Functions | |||
Find last instance of character in text | Excel Discussion (Misc queries) | |||
How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
How do I search for more than one text character in one cell? | Excel Worksheet Functions | |||
Search for a specific character in a cell in an if statement | Excel Worksheet Functions |