I am trying to convert or represent text as a number -- can Excel do this? Thanks
A Adam1 Chicago Jun 29, 2004 #1 I am trying to convert or represent text as a number -- can Excel do this? Thanks
G Gord Dibben Jun 29, 2004 #2 Adam More detail please. An example of the text you want as a number? Does your text look like numbers and you want it to be numbers? Gord Dibben Excel MVP On Tue, 29 Jun 2004 12:29:01 -0700, "Adam1 Chicago" <Adam1
Adam More detail please. An example of the text you want as a number? Does your text look like numbers and you want it to be numbers? Gord Dibben Excel MVP On Tue, 29 Jun 2004 12:29:01 -0700, "Adam1 Chicago" <Adam1
A Adam1 Chicago Jun 30, 2004 #3 It's standard text (in this case a stock ticker followed by a few other letters) that I am trying to convert to some numerical form. I'm not sure how Excel would do this, but I thought it might be able to.
It's standard text (in this case a stock ticker followed by a few other letters) that I am trying to convert to some numerical form. I'm not sure how Excel would do this, but I thought it might be able to.
G Gord Dibben Jun 30, 2004 #4 Adam Any way you could break out the numbers from the text? 1234asdf Formula =LEFT(A1,4) or Data>Text to Columns? A representative sample of some actual data to look at would be helpful for us to assist. Gord
Adam Any way you could break out the numbers from the text? 1234asdf Formula =LEFT(A1,4) or Data>Text to Columns? A representative sample of some actual data to look at would be helpful for us to assist. Gord
