Solved

Custom format text displays in Excel

Posted on 2014-04-23
2
307 Views
Last Modified: 2014-04-27
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
0
Comment
Question by:WeThotUWasAToad
2 Comments
 
LVL 12

Accepted Solution

by:
duttcom earned 500 total points
ID: 40019165
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
 

Author Comment

by:WeThotUWasAToad
ID: 40026225
That's perfect. It's great when such a simple and concise answer gives the solution. Many thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question