This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWL%3C/text%3E%3C/svg%3E)
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)
Hi, do you have more information about this problem now?
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.
Hi @William Li ,
Here is the guide for that.
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
A and E's strokes are 4?? ? How did you write the letter? There is no formula can get the result you need directly.
If its simple as you ask,
just use 'replace' function in excel to replace the alphabets in whole sheet or Workbook..
Hopeful it helps
hi! @William Li
you can refer this excel file. i made for your Question :)
Download and open the file changeletters.xlsx,
See cells formula
result sheet
insert text to cell[A11] → B12～ changed
B12=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)))