I use XL97 and Windows 2000. Try this:
In cell A1, put 13547.
In cell B1, put =LEN(A1). It returns 5, which I would expect.
In cell C1, put =RIGHT(A1,LEN(A1-2)). This returns 13547, which I would
NOT expect.
Why doesn't it return 547?
I use XL97 and Windows 2000. Try this:
In cell A1, put 13547.
In cell B1, put =LEN(A1). It returns 5, which I would expect.
In cell C1, put =RIGHT(A1,LEN(A1-2)). This returns 13547, which I would
NOT expect.
Why doesn't it return 547?
It's a misplaced parenthesis. Try
=RIGHT(A1,LEN(A1)-2)
James
It's all about brackets!
Try this..
=RIGHT(A1,(LEN(A1)-2))
Colin
Try this: =RIGHT(A1,LEN(A1)-2)
you need to put the -2 outside of the LEN bracket
"Brian" wrote:
> I use XL97 and Windows 2000. Try this:
>
> In cell A1, put 13547.
> In cell B1, put =LEN(A1). It returns 5, which I would expect.
> In cell C1, put =RIGHT(A1,LEN(A1-2)). This returns 13547, which I would
> NOT expect.
>
> Why doesn't it return 547?
>
Wouldn't you want
=RIGHT(A1,LEN(A1)-2).
"Brian" wrote:
> I use XL97 and Windows 2000. Try this:
>
> In cell A1, put 13547.
> In cell B1, put =LEN(A1). It returns 5, which I would expect.
> In cell C1, put =RIGHT(A1,LEN(A1-2)). This returns 13547, which I would
> NOT expect.
>
> Why doesn't it return 547?
>
Zone wrote:
> It's a misplaced parenthesis. Try
> =RIGHT(A1,LEN(A1)-2)
> James
>
Thanks to everybody. This is my Homer Simpson moment for today (I hope).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks