Excel Custom Formatting Adding Characters and Text

Sep 08, 2015 by azurous in Custom Formatting

When working with custom formats in Excel there may be times you want to add a specific character or text string before or after the cell value. I will be explain this using examples in this article.

–

Contents

Literal Characters:

There are certain characters that will be displayed exactly as they are in the custom format:

q	w	t	u	i	o
p	a	f	j	k	l
z	x	c	v	$	+
(	:	^	‘	{	<
=	–	/	)	!	&
~	}	>	(Space)

These characters and their uppercase equivalent will be displayed as they are.

Example:

In this example the character “q” will be added to the end of the number:

0q

Result:

Example:

In this example the character “a” will be added to the start of the text string:

a@

For more information about the “@” character please see the link below:

Excel Custom Formatting, @ Character

Result:

–

Backslash Character “”:

Another method for adding characters in custom formatting is using the backslash character. The character that comes after a backslash is displayed as it is in the custom formatting. I will explain this using examples:

Example:

In this example the characters “e” and “r” are added to the end of the number:

0er

Result: