How to Trim Aliases of Different Lengths?

Summary:

Is it possible to trim Aliases of different lengths in Reporting? We have to add member names to our Aliases to make them unique across all dimensions. Unfortunately, our member names within a dimension can be of varying lengths. Is there a way to trim the Alias using a formula so that is shows the values in the "Report to show" column? For example in excel you'd write a formula to tell it to ignore all characters up to and including the first space.