excelbetter
Board Regular
- Joined
- Oct 13, 2010
- Messages
- 190
I have a sheet with over 20,000 rows of item #'s in Column A of a sheet.
I am looking to:
1) Find all items that have 2 dashes (i.e. "-"), then...
2) For those that have 2 dashes, in a new column, put the contents of the item # that come after the second dash.
Sample data is below:
abc-scott-special
kjh-jkhsakjjkhkjh-SAM
CB-123456jkh-bob
EX-1824ABCXYZ-justoneday
AB-123455
AB-765432
AB-NOSECONDDASH
AB-TWODASHES-testhere
You'll see some of the above has 2 dashes, and some only have one.
Any thoughts on how to do this?
Thanks a million!
I am looking to:
1) Find all items that have 2 dashes (i.e. "-"), then...
2) For those that have 2 dashes, in a new column, put the contents of the item # that come after the second dash.
Sample data is below:
abc-scott-special
kjh-jkhsakjjkhkjh-SAM
CB-123456jkh-bob
EX-1824ABCXYZ-justoneday
AB-123455
AB-765432
AB-NOSECONDDASH
AB-TWODASHES-testhere
You'll see some of the above has 2 dashes, and some only have one.
Any thoughts on how to do this?
Thanks a million!