number plus alpha character plus symbol custom format

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
103
I need to create a custom cell format as follows:
Example: 17a >
This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc.
Do you get the picture?

Before the need for an alpha character this was simple. The custom format was either # ">" OR 0 ">".
Now with the additional alpha character being added such that in any given cell where this format exists I would type in a number and an alpha character and the result would simply add the > to the end of the number plus alpha character as in the below examples.
Any help is greatly appreciated.
10a >
10b >
10c >
13a >
13b >
13c >
13d >
16a >
17a >
18a >
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,099,331
Messages
5,467,984
Members
406,562
Latest member
tobruk

This Week's Hot Topics

Top