+ Start a Discussion
Daniel B ProbertDaniel B Probert 

=CODE equivalent in Salesforce



I currently have an excel formula that generates a random code based on the salesforce id.


i'm keen to move this into salesforce but can't find what formula would do the same.


this is the formula - imagine that A2 is the salesforce id.




The mid bit works fine I just can't find what formula I can use for the CODE.


Any help welcomed.




I don't think SF have equivalent function for this.
You can write such, but it will require apex code.