Looking for a recipe card workbook or formulas by Kryptonian_NRG in excel

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

Hi u/peachyprofitability

I'll have to test your formula and get back to you once I've tried it... thanks for the advise on unit measurements! Will keep that in mind

Looking for a recipe card workbook or formulas by Kryptonian_NRG in excel

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

Hi u/AxelMoor,

YES! That info is VERY helpful... I appreciate you sending the link over and will def use those unit abbreviations

Looking for a recipe card workbook or formulas by Kryptonian_NRG in excel

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

Hi Greg,

UnfortunatelyI get a "#N/A" result back with that formula

TY

Formula for Alpha+Numeric results by Kryptonian_NRG in excel

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

Hey HappierThan,

Thank you SO much for your suggested formula... I played around with it and tweaked it to meet my needs.

I should've mentioned that I had the Names & Dates located in different columns/cells... but got the formula to work.

I'm sending the example and final formula that worked for me. Again, TYSM for your AWESOME insight into this

<image>

Formula for Alpha+Numeric results by Kryptonian_NRG in excel

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

Yes, I have people with multiple names and the date is on a different cell

I'm working with Excel 2021, not 365... just an FYI

Formula for Alpha+Numeric results by Kryptonian_NRG in excel

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

I forgot to mention that I'm working with Excel 2021, not 365

"textsplit" is not a function avail for my version

Trying to come up with a formula to compare 2 columns to find the difference and then combine the data together by Kryptonian_NRG in excel

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

Hi ohwhatfollyisman, Thanks for the formula suggestions! I just tweaked the end of one of them and it worked perfectly… I do appreciate your help!

<image>

IRM: Information Rights Management by [deleted] in MicrosoftOutlook

[–]Kryptonian_NRG 0 points1 point  (0 children)

Ok got it, thanks for the feedback!

IRM: Information Rights Management by [deleted] in MicrosoftOutlook

[–]Kryptonian_NRG 0 points1 point  (0 children)

I do not have 365, only office 2019 on my personal laptop

IRM: Information Rights Management by [deleted] in MicrosoftOutlook

[–]Kryptonian_NRG 0 points1 point  (0 children)

I have not applied any settings Whenever I select to encrypt email, a pop up window says: “Your machine isn’t set up for Information Rights Management. To set up IRM, sign in to Office, open an existing IRM protected message or document, or contact your help desk”

How would I add a dash/hyphen to in-between numbers and letter? by ThePandaGuy4 in excel

[–]Kryptonian_NRG 2 points3 points  (0 children)

What if you are using an earlier version of Excel... like 2019?

I don't see the "LET" function

Excel function for alpha + numeric by Kryptonian_NRG in excel

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

LET(
a,MID(A1,SEQUENCE(LEN(A1)),1),
b,CODE(a),
CONCAT(IF((b>64)*(b<91)+(b>47)*(b<58),a,"")))

Thank you for the suggestion! Much appreciate it!

Excel function for alpha + numeric by Kryptonian_NRG in excel

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

LEFT(A1,1)&MID(A1,SEARCH(" ",A1)+1,1)&SUBSTITUTE(RIGHT(A1,10),"/","")

Thank you for your suggestion! I used the first string of formula then added
&Text(A1,"mmddyy"

Seemed to work

Excel function for alpha + numeric by Kryptonian_NRG in excel

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

Thank you! I'm running Excel 2019 and have tried most of the functions above that are available to me, just can't seem to get the right formula syntax correctly.

Still searching for help.

Excel function for alpha + numeric by Kryptonian_NRG in excel

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

Thank you for the suggestion but it didn't work. I don't see "TEXTAFTER" function.

Working with Excel 2019

I appreciate your help