removing certain text from a string

P

Papa Jonah

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
 
T

Tom Ogilvy

Sub TTT()
sStr = "xxx-xx-xxx-xxxxxyyyyy-nnnn-nnnn"
v = Split(sStr, "-")
MsgBox v(3)
End Sub

Requires xl2000 or later
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I delete a space/character from a number of fields? 10
Need help removing extra TOC text from number lists used as TOC levels 0
concatenate entries from a column into a cell by logical AND withanother column 2
Code copies between key word is in reverse order 5
Delete certain text from cells 2
Extract each line of text from a textbox into an array 4
Removing text between hyphens and removing the hyphens 8
Search text string for ssn and copy to new column 8

Top