You are here:

Advanced Math/Unicode Characters Data in Excel.


Dear Prof Scott

Can we store Unicode characters data in Excel ?. In that case can we store in Text , General etc cell fields for storing unicode characters ?.

Are there string functions in Excel application related to Unicode characters  ?.

Thanks & Regards,
Prashant S Akerkar

Now all Unicode characters use to be usable back when Lotus was the spreadsheet I used,
but since then they have changed on various computers.  For example, alt-251 is √, alt-253 ,
alt-254 is still ■, alt-252 is ⁿ, alt with a number near 200 is a corner in a set of squares,
and others can still be used as well, such as alt-3, alt-4, alt-5, and alt-6 are the heart, diamond, club, and spade (the suits in a deck of playing cards).  The character alt-19 is ‼,
which is for an important expression, and the alt-20 is , which is commonly used in Word for a return.

Using A1 as 1 and each cell below it as the one above plus one, I then put =char(A1) in B1 and copied it on down.  I got some character in almost every cell.  Note that 65 is A (since that is 2^6 + 1) and 97 is a (since that is 2^6 + 2^5 + 1).  In Excel, the alt-200's aren't the edge of box characters as in other languages.

Characters 1, 9, 10, and 28 - 32 don't show anything.
In most documents, alt-9 and alt-10 are a line feed and carriage return, but I don't remember which is which.  I don't have any clue what 28, 29, 30, 31, and 32 are used for.  Apparently the box characters has been replaced with characters from other languages.

I don't believe there are any applications of any of these characters.

Advanced Math

All Answers

Answers by Expert:

Ask Experts


Scott A Wilson


I can answer any question in general math, arithetic, discret math, algebra, box problems, geometry, filling a tank with water, trigonometry, pre-calculus, linear algebra, complex mathematics, probability, statistics, and most of anything else that relates to math. I can also say that I broke 5 minutes for a mile, which is over 12 mph, but is that relevant?


Experience in the area; I have tutored people in the above areas of mathematics for over two years in I have tutored people here and there in mathematics since before I received a BS degree back in 1984. In just two more years, I received an MS degree as well, but more on that later. I tutored at OSU in the math center for all six years I was there. Most students offering assistance were juniors, seniors, or graduate students. I was allowed to tutor as a freshman. I tutored at Mathnasium for well over a year. I worked at The Boeing Company for over 5 years. I received an MS degreee in Mathematics from Oregon State Univeristy. The classes I took were over 100 hours of upper division credits in mathematical courses such as calculus, statistics, probabilty, linear algrebra, powers, linear regression, matrices, and more. I graduated with honors in both my BS and MS degrees. Past/Present Clients: College Students at Oregon State University, various math people since college, over 7,500 people on the PC from the US and rest the world.

My master's paper was published in the OSU journal. The subject of it was Numerical Analysis used in shock waves and rarefaction fans. It dealt with discontinuities that arose over time. They were solved using the Leap Frog method. That method was used and improvements of it were shown. The improvements were by Enquist-Osher, Godunov, and Lax-Wendroff.

Master of Science at OSU with high honors in mathematics. Bachelor of Science at OSU with high honors in mathematical sciences. This degree involved mathematics, statistics, and computer science. I also took sophmore level physics and chemistry while I was attending college. On the side I took raquetball, but that's still not relevant.

Awards and Honors
I earned high honors in both my BS degree and MS degree from Oregon State. I was in near the top in most of my classes. In several classes in mathematics, I was first. In a class of over 100 students, I was always one of the first ones to complete the test. I graduated with well over 50 credits in upper division mathematics.

Past/Present Clients
My clients have been students at OSU, people who live nearby, friends with math questions, and several people every day on the PC. I would guess that you are probably going to be one more.

©2017 All rights reserved.