如何使用vba正确地重新格式化具有多种变体的维度值?

I'm trying to create an Excel macro that formats dimension values into our company's format. That way we can easily import the data into our systems without having to do thousands of dimensions manually. There are a few problems I'm running into though:I'm trying to create an Excel macro that format