Extracting Characters from strings.

[MadYowie]

Hi All

Need some rookie help to understand the following.

When using the MID or RIGHT functions to return charaters from a string, why doesn't the function start from a "0"?

example: Cell A1 = 0.08
Cell A2 = 0.10


RIGHT(A1,2) returns "08" as intentend, though RIGHT(A2,2) RETURNS ".1", ignoring the first 0. instead of "10"


How can I retrive the required caracters if it starts with a "0"

Thanks for you help.

[jtakw]

Hi,

That's because that 0 isn't really there, you probably have the cell formatted Number with 2 decimal places.

[Ron Coderre]

The value you see is the formatted value.
The actual value is what's in the cell. Cell A2 contains 0.1 and it happens to be formatted as 0.10

You'll need to convert the value to formatted text.
Try this regular forumula, copied down

Please Login or Register  to view this content.

Is that something you can work with?

[jtakw]

If you really want 10 as the result, you can do this:

Excel 2016 (Windows) 64 bit

	A	B	C
1	0.08		08
2	0.10		10

Sheet: Sheet32

Excel 2016 (Windows) 64 bit

	C
1	=RIGHT(TEXT(A1,"0.00"),2)

Sheet: Sheet32

[AlKey]

Or do this

Please Login or Register  to view this content.

v	A	B
1	0.08	08
2	0.1	10

[MadYowie]

Thanks everyone, I understand the function better now and this has solved my issue,