Bacon is so good by itself that to put it in any other food is an admission of failure. You're basically saying, "I can't make this other food taste good, so I'll throw in bacon."
excel left function can it return numerical values
Dan
16 years ago
Hi i need to be able to return numerical values from part of a text string using the left function eg
text string
12345 NW11 6PQ
would like to return
12345 as a number not text, currently i have to use the left function and then copy paste values and then convert to number, is there an easier way? Answer from Richard Rost:
You could always use the INT function:
=INT(LEFT(A1,5))
It's cheezy, but it works.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
