If you have Office 365:
=TEXTJOIN(" ",,CODE(MID(A1,SEQUENCE(LEN(A1)),1)))
or
= ARRAYTOTEXT(CODE(MID(A1,SEQUENCE(LEN(A1)),1)),0)
Top answer 1 of 3
6
If you have Office 365:
=TEXTJOIN(" ",,CODE(MID(A1,SEQUENCE(LEN(A1)),1)))
or
= ARRAYTOTEXT(CODE(MID(A1,SEQUENCE(LEN(A1)),1)),0)
2 of 3
1
For Excel 2016, a formula-based solution will only be feasible for strings containing no more than 5 characters, viz:
=TRIM(SUBSTITUTE(SUBSTITUTE(TEXT(SUMPRODUCT(10^(15-3*(ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1)))-1))*CODE(MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1))),REPT(" 000",6))," 00"," ")," 0"," "))
Otherwise, you'll require VBA.
MrExcel
mrexcel.com › forums › question forums › excel questions
Convert a character to its ASCII value | MrExcel Message Board
December 14, 2011 - I thought (remembered?) it was easy to convert a char to ASCII using ASC() as follows: Col B is formatted to type=Number A1 holds "N" B1 holds =ASC(A1) expected but got "N" another attempt: B1 holds =ASCII(A1) #NAME I searched MRExcel and google ...
Convert a string of hex to ASCII
See if this works for you =TEXTJOIN("",,CHAR(HEX2DEC(MID(D2,(2*ROW(INDIRECT("1:"&LEN(D2)/2)))-1,2)))) This is an array formula so enter with CTRL + SHIFT + ENTER if you don't have a version with dynamic arrays. This replaces n in your formula with an array of 1, 3 ,5, 7 ... to X-1 where X is the length if your text. Working from the inside out LEN(D2)/2 takes the lenght of D2 and divides by 2 to get your number of pairs "1:"&LEN(D2)/2 givea you a text string that looks like 1:Y where Y is the definition above INDIRECT("1:"&LEN(D2)/2).creates a cell reference matching the definition above ROW(INDIRECT("1:"&LEN(D2)/2)) gets the row numbers associated with the cell reference above, so 1, 2, 3, ..., Y where Y is as defined above (2*ROW(INDIRECT("1:"&LEN(D2)/2))) multiplies the numbers from the above step by 2, so you have 2, 4, 6, 8, ...., 2Y (2*ROW(INDIRECT("1:"&LEN(D2)/2)))-1 subtracts 1 from the above answers to get your starting positions, 1, 3, 5, 7, X-1, where X is length of your text and also 2Y More on reddit.com
10
1
July 12, 2020Decimal To Ascii In Excel
If there are any Excel guys there ... Ascii in Excel I sure would appreciate it. ... I think you can use =CHAR(x) where x is the number or cell you want to convert to an ASCII character ... Hmmm I'm not sure then, because I just tried =CHAR(B1) in cell A1 and it returned exactly what I was expecting when I typed a number in B1 ... Let me be a little more clear. I'm getting a number in decimal from CLX that represents an Ascii text... More on plctalk.net
25
July 3, 2013Importing a huge ASCII file that doesn't have delimiters?
u/urabignerd - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
7
2
February 10, 2022*.spc to text/xlsx?
I don't know what *.spc is but is there a way to read it into Matlab? If there is then you can download octave which is the free and takes the Matlab language. Writing to an xlsx is then a line or two of code. More on reddit.com
7
2
October 20, 2016How do I convert ASCII codes back to characters?
Use the CHAR function, which is the inverse of CODE. For example, =CHAR(65) returns "A". CHAR works with ASCII values 1-255. For Unicode values, use UNICHAR function in Excel 2013+.
getelyxai.com
getelyxai.com › excel formulas › text › code
Excel CODE Formula: Get ASCII Character Codes | ElyxAI
What ASCII codes should I know for common validation scenarios?
Uppercase letters: 65-90 (A-Z), Lowercase letters: 97-122 (a-z), Numbers: 48-57 (0-9), Space: 32, Common punctuation: 33-47 (! to /), 58-64 (: to @), 91-96 ([ to `). These ranges help build validation formulas.
getelyxai.com
getelyxai.com › excel formulas › text › code
Excel CODE Formula: Get ASCII Character Codes | ElyxAI
What's the difference between CODE and UNICODE functions?
CODE returns ASCII values (0-255) for standard characters and works in all Excel versions. UNICODE returns Unicode code points for any character, including international symbols and emojis, and is available in Excel 2013 and later. Use CODE for ASCII text and UNICODE for extended character sets.
getelyxai.com
getelyxai.com › excel formulas › text › code
Excel CODE Formula: Get ASCII Character Codes | ElyxAI
Videos
How to convert text to hexadecimal (ASCII) with a Recursive Lambda ...
03:35
ASCII Converter Demonstration - YouTube
12:05
Create ASCII and HTML Color Code Calculators in Excel - YouTube
06:56
Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick ...
04:07
Convert Hex characters to ASCII characters in Excel - YouTube
How to convert ASCII to Characters in Excel?
AEPOCH
aepochadvisors.com › home › excel guides › converting to ascii text in excel
How to Convert to ASCII Text in Excel (2 Simple Methods)
May 6, 2023 - You can do this by clicking on ... to convert the word “hello”, enter it into cell A1. Next, use the “CODE” function to convert the text to ASCII code....
ElyxAI
getelyxai.com › excel formulas › text › code
Excel CODE Formula: Get ASCII Character Codes | ElyxAI
The CODE function in Excel is a powerful text manipulation tool that converts the first character of a text string into its corresponding ASCII (American Standard Code for Information Interchange) numeric value. This function proves invaluable when working with character encoding, data validation, ...
Excelbanter
excelbanter.com › excel-discussion-misc-queries › 122231-how-do-i-take-string-text-convert-ascii-values.html
How do I take a string of text and convert it ASCII Values? - ExcelBanter
I have a column containing a string of text of a fixed width, and I need to make another column out that displays the ASCII values. How can I do this?
Encyclopedia-Excel
encyclopedia-excel.com › how-to-return-the-ascii-number-for-every-character-in-a-cell
How to Return the ASCII Number for Every Character in a Cell | Encyclopedia-Excel
April 6, 2023 - For every ASCII number listed in a single cell (as in the picture above), you can use the following formula: =TEXTJOIN(" ",,CODE(MID(string, SEQUENCE(LEN(string)), 1)))
Officetuts
officetuts.net › home › convert text to ascii in excel
Convert Text to ASCII in Excel
March 29, 2024 - Learn how to convert text to ASCII codes in Excel using the CHAR and CODE functions. Download the Convert-Text-to-Ascii Excel file and follow the tutorial.
Reddit
reddit.com › r/excel › convert a string of hex to ascii
r/excel on Reddit: Convert a string of hex to ASCII
July 12, 2020 -
Hey,
I have a desire to convert strings from 20 to 250 characters in length from hex pairs to ASCII. So for example "Hello, world!" is (without the quotes) is represented by 48656C6C6F2C20776F726C6421.
I have built a sheet in my workbook to do this, but it is brutally huge, because I basically made 125 columns to separate each pair, then 125 more columns to convert the hex value to dec, then 125 MORE columns to convert the dec value to ASCII, and one final column to TEXTJOIN the whole mess.
I realize now I could probably reduce a lot of those middle steps by combining my equations, i.e. char(hex2dec(mid(D2,n,2))) (where n is 1, 3, 5, ...) but that still leaves me with 125 columns to textjoin. Bonus - as I said this can range from 20 to 250 characters in length, so I need to take that into consideration. The quick & (very) dirty method I'm using above simply converts 125 pairs even if there aren't 125 to do - my equations just put blank cells in place of invalid ranges (i.e. if the message is only 200 characters long, there are 25 blank columns at the end) - this doesn't pad my message out with spaces in the textjoin, but if building some kind of code to automate this with a much smaller set of equations, I figure that will need to be taken into consideration.
I'm not good with functions, macros, or VB. I prefer to work in equations because I at least understand them. If you intend to suggest something like that, I may need some additional hand-holding.
Any thoughts? I'm sure there's something much simpler I'm overlooking.
Thanks!
Top answer 1 of 3
4
See if this works for you =TEXTJOIN("",,CHAR(HEX2DEC(MID(D2,(2*ROW(INDIRECT("1:"&LEN(D2)/2)))-1,2)))) This is an array formula so enter with CTRL + SHIFT + ENTER if you don't have a version with dynamic arrays. This replaces n in your formula with an array of 1, 3 ,5, 7 ... to X-1 where X is the length if your text. Working from the inside out LEN(D2)/2 takes the lenght of D2 and divides by 2 to get your number of pairs "1:"&LEN(D2)/2 givea you a text string that looks like 1:Y where Y is the definition above INDIRECT("1:"&LEN(D2)/2).creates a cell reference matching the definition above ROW(INDIRECT("1:"&LEN(D2)/2)) gets the row numbers associated with the cell reference above, so 1, 2, 3, ..., Y where Y is as defined above (2*ROW(INDIRECT("1:"&LEN(D2)/2))) multiplies the numbers from the above step by 2, so you have 2, 4, 6, 8, ...., 2Y (2*ROW(INDIRECT("1:"&LEN(D2)/2)))-1 subtracts 1 from the above answers to get your starting positions, 1, 3, 5, 7, X-1, where X is length of your text and also 2Y
2 of 3
2
Unless you are looking for a UDF or VBA solution, what you are doing sounds exactly right. The cell with the final TEXTJOIN can be to the left of all the helper columns, and the helper columns can be hidden, but if you understand what you've got and and its giving you the right result, I think you've got it.
Rpmitconsulting
rpmitconsulting.com › blog › excel-tricks-reversechar-convert-a-charcter-to-its-ascii-number
ReverseChar - Convert a character to its ASCII number
October 3, 2016 - Specialists in the analysis, design, build and testing of financial, engineering and mathematical spreadsheets, tools and websites.
Excel Tips
excel.tips.net › T011492_Converting_to_ASCII_Text.html
Converting to ASCII Text - Microsoft Excel Tips
The result is "cleaned" text, without the non-printables. If you want to replace foreign characters with regular ASCII characters, that will need to be done with a macro. Here's an example of a relatively straightforward approach: Sub StripAccent() Dim sAcc As String Dim sReg As String Dim sA As String Dim sR As String Dim i As Integer sAcc = "������������������������������������������������������������" sReg = "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy" For i = 1 To Len(sAcc) sA = Mid(sAcc, i, 1) sR = Mid(sReg, i, 1) Selection.Replace What:=sA, Replacement:=sR, _ LookAt:=xlPart, MatchCase:=True Next End Sub
ExcelTips (ribbon)
excelribbon.tips.net › T010425_Converting_Codes_to_Characters.html
Converting Codes to Characters (Microsoft Excel)
February 1, 2020 - Excel includes a built-in worksheet function that allows you to convert numeric values into their associated characters, as follows: ... This example function converts the numeric value at A3 to its corresponding character. The conversion is done using an extended ASCII character set.
CodeShack
codeshack.io › home › tools › text to ascii code converter
Text to ASCII Code Converter - Online Tool
Output ASCII Codes: ... This tool converts any text string into its corresponding ASCII (American Standard Code for Information Interchange) or more broadly, Unicode code point values. You can choose to view these codes in various numerical bases: Decimal, Hexadecimal, Binary, or Octal.
ManyCoders
manycoders.com › excel › converting-to-ascii-text
Converting To Ascii Text In Excel - ManyCoders
August 5, 2025 - Are you struggling to convert text to ASCII in Excel? Here is a comprehensive guide to help you unlock the power of Excel and learn how to convert text to
MyExcelOnline
myexcelonline.com › home › how to use ascii characters in excel
How to Use ASCII Characters in Excel | MyExcelOnline
May 13, 2025 - The syntax follows the format =CHAR(number), where “number” is the ASCII code that you wish to convert into a character. For instance, =CHAR(65) returns the letter “A”. This capability is crucial when constructing text from ASCII values, ...
MyExcelOnline
myexcelonline.com › home › the ultimate guide to asc2 converter in excel
The Ultimate Guide to ASC2 Converter in Excel | MyExcelOnline
September 8, 2025 - Excel’s CODE and CHAR functions allow you to move back and forth between these forms. The ASC2 Converter in Excel is a robust tool that transforms text characters into their numeric ASCII values.
PLCS.net
plctalk.net › home › forums › q & a › plc questions and answers
Decimal To Ascii In Excel | PLCtalk - Interactive Q & A
July 3, 2013 - If there are any Excel guys there ... Ascii in Excel I sure would appreciate it. ... I think you can use =CHAR(x) where x is the number or cell you want to convert to an ASCII character ... Hmmm I'm not sure then, because I just tried =CHAR(B1) in cell A1 and it returned exactly what I was expecting when I typed a number in B1 ... Let me be a little more clear. I'm getting a number in decimal from CLX that represents an Ascii text...
npm Cheatsheet
lwebapp.com › en › excel-to-ascii
Excel to ASCII
Online tool for converting Excel to ASCII characters in real time
Table Convert
tableconvert.com › home › convert excel to ascii text table online
Convert Excel to ASCII Text Table Online - Table Convert
July 28, 2025 - For Excel to ASCII conversion, paste a table, upload a file, and copy clean ASCII output. To convert Excel to ASCII reliably, you can review the table first and then export the final ASCII result.
ExcelDemy
exceldemy.com › home › excel functions › how to convert excel ascii to char
How to Convert Excel ASCII to Char - ExcelDemy
August 11, 2024 - The CODE function converts the characters into ASCII codes or numbers. The VBA Asc function returns the same output as the CODE function in Excel VBA. ⧭ Note: The modern Unicode system supports universal characters.
TechOnTheNet
techonthenet.com › excel › formulas › code.php
MS Excel: How to use the CODE Function (WS)
The syntax for the CODE function in Microsoft Excel is: ... The specified character to retrieve the ASCII value for. If there is more than one character, the function will return the ASCII value for the first character and ignore all of the characters after the first.