trimming a single space between words

I'm trying to make a unique Account Number.

I want to take the first 6 characters of the Account Name.

The Account Name is: HSBC Delaware

When i do: UPPER(TRIM(LEFT( Name, 6)))

I get: Account Number: HSBC D

I would like it to be: HSBCDE

Any ideas on how to remove all spaces from a text string including the single space between words??

Best Answer chosen by Admin (Salesforce Developers)

Rpee
UPPER( LEFT( SUBSTITUTE( Name , " " , "" ) , 6 ) )

Rpee
UPPER( LEFT( SUBSTITUTE( Name , " " , "" ) , 6 ) )

This was selected as the best answer

Estee
THANK YOU SO VERY MUCH! That worked perfectly!!

Need an account? Sign Up

Have an account? Sign In