Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @William Li ,
Here is the guide for that.
Formula in Excel
William Li
1
Reputation point
Dear Sirs,
I want to create formula in excel as follow:
A change to 4
B change to 3
C change to 1
D change to 2
E change to 4
.
.
.
Z change to 1
(i.e. Change English letters into number of strokes)
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
Emi Zhang-MSFT 30,116 Reputation points Microsoft External Staff
2020-08-28T09:29:43.1+00:00 Hi, do you have more information about this problem now?
-
Emi Zhang-MSFT 30,116 Reputation points Microsoft External Staff
2020-09-01T08:22:02.86+00:00 Hi @William Li , I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.
Sign in to comment
5 answers
Sort by: Most helpful
-
-
Alexis Veras 16 Reputation points
2020-08-15T16:56:33.703+00:00 Hi @William Li
could you please explain the logic of your formula:example:
why "A" and "E" change to 4
why "C" and "Z" change to 1 -
Emi Zhang-MSFT 30,116 Reputation points Microsoft External Staff
2020-08-17T05:49:21.503+00:00 A and E's strokes are 4?? ? How did you write the letter? There is no formula can get the result you need directly.
-
Hassan Mehmood Khan 6 Reputation points
2020-09-18T16:05:10.437+00:00 If its simple as you ask,
just use 'replace' function in excel to replace the alphabets in whole sheet or Workbook..
Hopeful it helps
-
Nobuko Ichimaru 321 Reputation points
2020-10-09T07:40:45.783+00:00 hi! @William Li
you can refer this excel file. i made for your Question :)
Download and open the file changeletters.xlsx,
See cells formularesult sheet
insert text to cell[A11] → B12～ changedB12=IF(A11="","",MID(A11,SEQUENCE(1,LEN(A11)),1))
B13=IF(ISERROR(INDEX(〇Changelist!$A$1:$B$27,MATCH(B12,〇Changelist!$A:$A,0),2)),"",(INDEX(〇Changelist!$A$1:$B$27,MATCH(B12,〇Changelist!$A:$A,0),2)))