indirect data validation w/ numbers and special characters

[Livin404]

Good morning,

I have a workbook where I’m using indirect validation to breakdown compliance procedures for processes we’re required to perform. I’m breaking down our source materials from Sections, to Paragraphs, and finally subparagraphs. After I finished with the base data validation, I may have a paragraph that may look like “26. Passengers with a Unique CIC (MMO, MRS, MEP, Cadet, and Couriers).”

For my name range I have “_26PassengerswithaUniqueCICMMOMRSMEPCadetandCouriers” I can get my spaces in there by using this code. “=indirect(Substitute($B25,” “,””))” .

So I end up with _26 Passengers with a unique CIC MMO MRS MEP Cadet and Couriers

I’m trying to remove the “_” at the beginning and add”.”, “(“,”)” etc. I would greatly appreciate any help in this matter.

Thank you very much indeed.

 

[Livin404]

Some characters were distorted when I posted. I hope this provides better clarity.

I have a workbook where I’m using indirect validation to breakdown compliance procedures for processes we’re required to perform. I’m breaking down our source materials from Sections, to Paragraphs, and finally subparagraphs. After I finished with the base data validation, I may have a paragraph that may look like “26. Passengers with a Unique CIC (MMO, MRS, MEP, Cadet, and Couriers).”

For my name range I have “_26PassengerswithaUniqueCICMMOMRSMEPCadetandCouriers” I can get my spaces in there by using this code. “=indirect(Substitute($B25,” “,””))” .

So I end up with _26 Passengers with a unique CIC MMO MRS MEP Cadet and Couriers

I’m trying to remove the “_” at the beginning and add”.”, “(“,”)” etc. I would greatly appreciate any help in this matter.