if i have a series of cells with numbers and letters (i.e. 43A or 33B, etc)
how can i get excel to see them only as numbers so when i graph them they
show up as 43 or 33 but also include the letter in the data label.

Right now I have to delete the text from the cells before i graph them, then
manually insert them in the data label after i create the graph. I'm hoping
there's away to graph it with the letter in tact.