for example
100 A-B
7 C-D
56 A-b
65 A-b

Those are not numbers.

100 A-B in one cell is already text.

What do you mean by your subject line?


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 17:18:01 -0800, Brenda
wrote:

for example
100 A-B
7 C-D
56 A-b
65 A-b

you can 'convert' it to text. by using =Text(cell, "General")

the "General" is the format string you can find in the format dialog box,
pick a format you like, click custom and you can copy and paste it.

any number you add this ' before the formula and it become text.


"Brenda" wrote:

for example
100 A-B
7 C-D
56 A-b
65 A-b