Hi everyone, it's been many years since I've posted anything to Mr. Excel and I was glad to see that the community is alive and well after all these year. I've searched through the forum and didn't find an thread that already answered this questions so I thought I would post it and see if there is a solution.
I am looking for a formula that will help me add the "+" character to all words in a cell that are at least 4 letters.
So, if this was the original data:
[TABLE="width: 588"]
<tbody>[TR]
[TD="width: 588"]
After I run the formula the result would look like:
I'd love any help you are able to offer.
Thank you
[/TD]
[/TR]
</tbody>[/TABLE]
I am looking for a formula that will help me add the "+" character to all words in a cell that are at least 4 letters.
So, if this was the original data:
[TABLE="width: 588"]
<tbody>[TR]
[TD="width: 588"]
- 02 59L Dodge Cummins Air Intakes Filters
After I run the formula the result would look like:
- 02 +59L +Dodge +Cummins Air +Intakes +Filters
I'd love any help you are able to offer.
Thank you
[/TD]
[/TR]
</tbody>[/TABLE]