Converting or representing text as a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to convert or represent text as a number -- can Excel do this?
Thanks
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Converting time (raw) into ss:mm 1
Largest Prime Number 9
convert numbers with K and M 7
Can I show text that represents a number 4
i want to convert decimals into time format 3
Converting Text to Function 3
This cell contains a date string rep. with only 2 digits for the y 5

Back
Top