Excel - How to?

[Velky]

What type of formula do I need to use that will bring up a certain character from a cell?

Ex:

If in A1 I have "123", and in B1 I want to input the 2nd and 3rd characters from A1 (I'll end up with "23" in B1).

[Fuzzykins]

There's no easy way to do that, AFAIK. Though, I could be wrong. Did you try googling?

[Velky]

I'm googling right now.

I just finished a basic excel course at Uni and I remember a formula I used that brought up a set of numbers in a serial number. Will have to go digging, or continue on google.

[llDemonll]

=mid(x, y, z)

x = cell reference
y = start position (first position is 1, not 0)
z = number of chars to extract

so for you:

=mid(A1, 2, 2)

will do the trick

[Velky]

=mid(x, y, z)

x = cell reference
y = start position (first position is 1, not 0)
z = number of chars to extract

so for you:

=mid(A1, 2, 2)

will do the trick

Much love!

Edit: Actually it's giving me "ERR" rather than reporting my number.

I want to bring up the 1st number in A100, which is 100. I typed "=mid(A100,1,1)".

Am I missing something?

---------- Post added 2011-08-12 at 06:28 PM ----------

I forgot I'm not using Excel, but Microsoft Works. When I googled "mid" function, it gave me the same thing you did, except the example had quotes around it. When I add quotes, it will bring up what character I want, however since it reads it as a text, I can't hold and drag to the rest of my cells.

I put "=mid("A100",1,1)"

---------- Post added 2011-08-12 at 06:55 PM ----------

Nvm, forgot I had Excel on my laptop and got what I was looking for.

[llDemonll]

thats good

also, using quotes in something like that will make what's in quotes a literal string, so your equation was working correctly, it was just seeing "A100" as the string it was supposed to trim, and not the value that was in the cell A100

[B@nj0 P3do]

=A1-100

^should work :P

[Velky]

=A1-100

^should work :P

Actually I had to run the mid function 3 separate times, between the numbers 100-999, so your option would of taken awhile