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??
I did
(TEXT(CreatedDate)
to get the date to display: 2009-03-29 13:17:30
I then used the LEFT function to get only the date
LEFT(TEXT(CreatedDate)),10)
2009-03-29
But I want 03292009.
How can I do this?? I tried TRIM, but that only removes spaces and tabs. And I cant see how to set the date to do MMDDYYYY
My final formula displays: LEFT(TRIM(TEXT(CreatedDate)),10)
