Hi Everyone,

I have a simple question that the answer could be to do it on excel, but I am wondering if this is possible to be done on STATA.

my variable is "installer_name" that has a list of the solar installer in California. One installer, for example, is called "Sun power", however, I need all the names that consist of two-words to be combined on one single word like this "Sunpower".

Does anyone know how this could be done on stata?

Best
Ali