Formula to identify Encrypted User first/User Last Name

[rmorello]

Can anyone help with the formula to find encrypted User names?

Thanks in advanced.

 

[felixstraube]

Actually there is equivalent for excel called "GPT for Excel Word".

 

[felixstraube]

Once intalled you can try this:

Book1
	A	B
1	Name	ChatGPT response
2	Ana	name
3	Bob	name
4	Liam	name
5	Sophia	name
6	Isabella	name
7	asdfadf	no name
8	zgerdgh	no name
9	gadsfa	no name
10	tyurefgf	no name
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=GPT_CLASSIFY(A2, {"name","no name"})

worked great for me.

 

[felixstraube]

Change the category to "person name". this way it wont recognize weird letter sequences as names:

Book1
	A	B
1	Name	ChatGPT response
2	Ava	person name
3	Charlotte	person name
4	Ava	person name
5	Ethan	person name
6	Isabella	person name
7	Liam	person name
8	Mia	person name
9	Noah	person name
10	Oliver	person name
11	William	person name
12	Ana	person name
13	apple	no name
14	asdfadf	no name
15	Bob	person name
16	book	no name
17	chair	no name
18	cloud	no name
19	elephant	no name
20	fire	no name
21	gadsfa	no name
22	guitar	no name
23	Isabella	person name
24	Liam	person name
25	moon	no name
26	mountain	no name
27	ocean	no name
28	Sophia	person name
29	Sophie	person name
30	tyurefgf	no name
31	zgerdgh	no name
32	xqjrp	no name
33	abcdew	no name
34	lmnopqrst	no name
35	zyxwvutsr	no name
36	kjhgf	no name
37	poiuy	no name
38	qazwsx	no name
39	edcrfv	no name
40	nbvcx	no name
41	lkjhgfdsewa	no name
Sheet1

Cell Formulas
Range	Formula
B2:B41	B2	=GPT_CLASSIFY(A2, {"person name","no name"})