Could not figure out how to phase the problem.
Have tried to come up with a straight formula to do this but it seems like VBA is needed. (happy if someone disproves that and has a forumla)
For simplicity sake, we will say we have a wks with Column A for "Reciept numbers" and Column B; has text with Bracketed [ITEMS] and ad lib descriptions
I need to get a comma seperated listing of ONLY what is in the [BRACKETS] in a single cell, Ideally in Proper format (First Letter Of Each Word Capitalized) but I can do that another way seperately if need be.
This has been parsed or exported from an alternat source so unfortunately it is not consistant in how many [TERMS] are in each [CELL]
So Row 3 might have [TWO] [BRACKETED PHRASES] and Row 4, 5, and 6 might have one each, say [FOUR] [FIVE] [SIX] with plenty other words around them...
but all are associated with a single reciept (listed in A3) I want C3 to output: Two, Bracketed Phrases, Four, Five, Six
I guess the easiest way is if I upload an example wks that shows what I'm trying to have happen.
Like I mentioned, I have tried coming up with formulas to do this. like:=MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1) and many variations on that theme,.. but they all fail to capture multiple [BRACKETED PHRASES],. and if they do they capture all the text between the begining of the first bracketed phrase and the end of the last bracketed phrase,
It just looks like this requires VBA, and sadly , I'm feeling out of my depth after a few woeful attempts.
The key is just getting the Bracketed terms comma seperated into a single cell. Technically if that is done, I can eliminate the Brackets if they are still there, and I can change the capitalization.. But if it all happens in the macro, even better.
Very late here, Mind scrambled.
Thank you to any who attempt to help.
Really,
Bookmarks