| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing certain text from a string
I have a column of report designators that consist of a bunch of text
separated by hyphens xxx-xx-xxx-xxxxxyyyyy-nnnn-nnnn I want to end up with the text in the middle to be copied to another column. However, I can not (that I am aware of) use the mid function because the length of the strings between the hyphens can vary. Any suggestions would be greatly appreciated. TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing certain text from a string
Sub TTT()
sStr = "xxx-xx-xxx-xxxxxyyyyy-nnnn-nnnn" v = Split(sStr, "-") MsgBox v(3) End Sub Requires xl2000 or later -- Regards, Tom Ogilvy "Papa Jonah" wrote in message ... I have a column of report designators that consist of a bunch of text separated by hyphens xxx-xx-xxx-xxxxxyyyyy-nnnn-nnnn I want to end up with the text in the middle to be copied to another column. However, I can not (that I am aware of) use the mid function because the length of the strings between the hyphens can vary. Any suggestions would be greatly appreciated. TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing value within a string | Excel Worksheet Functions | |||
| Please help with removing text string | Excel Discussion (Misc queries) | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
| Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
| Removing characters from a text string | Excel Programming | |||
Linear Mode
