Custom format text displays in Excel

Hello,

Hello, in Excel (2013) is there a way to define custom formatting for letters in the same way it is possible for numbers?

For example, after selecting some range (say Col B) and clicking Format Cells > Number tab > Custom, entering

">>> "#" <<<"

causes any number entered in Column B to be enclosed by chevrons. So say that the number 3 is entered in cell B9. The result will appear thus:

>>> 3 <<<

My question is whether or not there's a way to create a similar custom format which will be applied with a text entry. In other words, it would enable you to enter the letter "w" in the cell and display it as:

>>> w <<<

Thanks
WeThotUWasAToadAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
duttcomConnect With a Mentor Commented:
You are almost there with ">>> "#" <<<" but you will need to use an @ symbol instead of the hash to indicate that you want the special format to be applied to text, not a number.

">>> "@" <<<"
0
 
WeThotUWasAToadAuthor Commented:
That's perfect. It's great when such a simple and concise answer gives the solution. Many thanks!
0
All Courses

From novice to tech pro — start learning today.