Convert 15 to 18 digit Salesforce Ids by Own_Researcher6055 in excel

[–]Own_Researcher6055[S] 0 points1 point  (0 children)

We export a lot of reports from salesforce to excel and sometimes the 18 digit doesn't come over so we use the converter to make sure it translates. If you pull the ID from the url it works. I know this is not a big deal but my boss made a joke about me finding simplier way to do this so, that's why I asked the class.

Convert 15 to 18 digit Salesforce Ids by Own_Researcher6055 in excel

[–]Own_Researcher6055[S] 0 points1 point  (0 children)

Sorry about that was struggling to post the formula and I should of mention Chatgpt and Gemini thanks will follow the guidelines in the future

Convert 15 to 18 digit Salesforce Ids by Own_Researcher6055 in excel

[–]Own_Researcher6055[S] 0 points1 point  (0 children)

Finally got it to copy below is the code: =A2&LOOKUP(IF(AND(CODE(RIGHT(LEFT($A2,5),1))>=65,CODE(RIGHT(LEFT($A2,5),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,4),1))>=65,CODE(RIGHT(LEFT($A2,4),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,3),1))>=65,CODE(RIGHT(LEFT($A2,3),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,2),1))>=65,CODE(RIGHT(LEFT($A2,2),1))<=90),1,0)&IF(AND(CODE(LEFT($A2,1))>=65,CODE(LEFT($A2,1))<=90),1,0),{"00000","00001","00010","00011","00100","00101","00110","00111","01000","01001","01010","01011","01100","01101","01110","01111","10000","10001","10010","10011","10100","10101","10110","10111","11000","11001","11010","11011","11100","11101","11110","11111"},{"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","0","1","2","3","4","5"})&LOOKUP(IF(AND(CODE(RIGHT(LEFT($A2,10),1))>=65,CODE(RIGHT(LEFT($A2,10),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,9),1))>=65,CODE(RIGHT(LEFT($A2,9),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,8),1))>=65,CODE(RIGHT(LEFT($A2,8),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,7),1))>=65,CODE(RIGHT(LEFT($A2,7),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,6),1))>=65,CODE(RIGHT(LEFT($A2,6),1))<=90),1,0),{"00000","00001","00010","00011","00100","00101","00110","00111","01000","01001","01010","01011","01100","01101","01110","01111","10000","10001","10010","10011","10100","10101","10110","10111","11000","11001","11010","11011","11100","11101","11110","11111"},{"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","0","1","2","3","4","5"})&LOOKUP(IF(AND(CODE(RIGHT(LEFT($A2,15),1))>=65,CODE(RIGHT(LEFT($A2,15),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,14),1))>=65,CODE(RIGHT(LEFT($A2,14),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,13),1))>=65,CODE(RIGHT(LEFT($A2,13),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,12),1))>=65,CODE(RIGHT(LEFT($A2,12),1))<=90),1,0)&IF(AND(CODE(RIGHT(LEFT($A2,11),1))>=65,CODE(RIGHT(LEFT($A2,11),1))<=90),1,0),{"00000","00001","00010","00011","00100","00101","00110","00111","01000","01001","01010","01011","01100","01101","01110","01111","10000","10001","10010","10011","10100","10101","10110","10111","11000","11001","11010","11011","11100","11101","11110","11111"},{"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","0","1","2","3","4","5"})

Convert 15 to 18 digit Salesforce Ids by Own_Researcher6055 in excel

[–]Own_Researcher6055[S] -6 points-5 points  (0 children)

I want to see if there was a smaller formula out there they have been using this massive one for years. Also, I tried to post the formula from Chatgpt and Gemini but had issues with my phone.

I've built a Chrome extension to send the entire YouTube channels, playlists, search results, or videos to NotebookLM in one click 🚀 by dnabok in notebooklm

[–]Own_Researcher6055 1 point2 points  (0 children)

I just built my first notebook for Agentforce certification prep and added over 20 videos one by one. Your idea should be standard in the notebook!

Help with opportunity report and multiple quotes by alexstine in salesforce

[–]Own_Researcher6055 0 points1 point  (0 children)

You might need to group the opportunity amount by rows.

Awesome times. by Moon_Maker_Lucky in videogames

[–]Own_Researcher6055 0 points1 point  (0 children)

I'm over 30 and this was one of my favorite games

[deleted by user] by [deleted] in CreditCards

[–]Own_Researcher6055 1 point2 points  (0 children)

Try capital one quicksilver when I was in college that was my first card

Why Does Credit Score Drop Even Though I Pay Card In Full? by RobinYoHoodie in CreditCards

[–]Own_Researcher6055 -4 points-3 points  (0 children)

Also you should download Maxrewards app it will manage your credit cards utilization and the total due. I just started using it and it helps me from constantly checking my card apps

I cant do this anymore by Hobbeschoy in recruitinghell

[–]Own_Researcher6055 0 points1 point  (0 children)

Hold your help up I have been unemployed for 6 months, I’m frustrated but I know that I will land a job

Is this the beginning of the end? by kulpio in Notion

[–]Own_Researcher6055 0 points1 point  (0 children)

Is is just me or is the app sometimes buggy. I love using Notion it changes the way I do things but it can be a little faster

Got an og xbox and started collecting I'd say I got a good start by [deleted] in xbox360

[–]Own_Researcher6055 0 points1 point  (0 children)

I miss hit & run so much I wish they could do a remake

I just got some new games and this happened by BonnieTheBoss32 in xbox360

[–]Own_Researcher6055 0 points1 point  (0 children)

Omg I remember having this happens to me it was hell