|
| Re: Qpro V8 : How to extract a few characters in between ? |
 |
Wed, 05 Mar 2008 12:48:14 -060 |
Low Seng Kuang wrote:
> Dear Sir,
>
> May I know how to select a few characters from a cell:
>
> Eg:
> A B
> 1 PKHCN2147 CN
> 2 PKHDJ6415 DJ
> 3 PKHTY8741 TY
>
> In Excel I used =MID(A1,4,2) at cell B1, but this formula is not working in
> Q Pro.
>
> May I know what should be the formula ?
>
> Thanks
>
> Low
>
>
>
It works the same but the definition of the start is different. Use:
@Mid(A1,3,2)
|
| Post Reply
|
| Re: Qpro V8 : How to extract a few characters in between ? |
 |
Wed, 05 Mar 2008 13:43:58 -060 |
You have answers to your question.
I notice you mention version 8 in your subject line. There are QPro
groups for various versions. For future reference, the group for
version 10 and earlier is:
news://cnews.corel.com/corel.QuattroPro_older_versions
Regards,
|
| Post Reply
|
| Re: Qpro V8 : How to extract a few characters in between ? |
 |
Wed, 05 Mar 2008 18:54:11 GMT |
Low:
> In Excel I used =MID(A1,4,2) at cell B1, but this formula is not working in
> Q Pro.
This works here: @MID(A1,3,2)
QP starts counting at 0 - the number is not cardinal but an offset.
--
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)
|
| Post Reply
|
| Qpro V8 : How to extract a few characters in between ? |
 |
Thu, 6 Mar 2008 02:31:34 +0800 |
Dear Sir,
May I know how to select a few characters from a cell:
Eg:
A B
1 PKHCN2147 CN
2 PKHDJ6415 DJ
3 PKHTY8741 TY
In Excel I used =MID(A1,4,2) at cell B1, but this formula is not working in
Q Pro.
May I know what should be the formula ?
Thanks
Low
|
| Post Reply
|
| Re: Qpro V8 : How to extract a few characters in between ? |
 |
Sat, 8 Mar 2008 01:10:18 +0800 |
Hello Kanneth,
Thanks for the formula.
Low
"Kenneth Hobson" <khobson@aaahawk.com> wrote in message
news:47ceea9b_1@cnews...
>
> Low Seng Kuang wrote:
>> Dear Sir,
>>
>> May I know how to select a few characters from a cell:
>>
>> Eg:
>> A B
>> 1 PKHCN2147 CN
>> 2 PKHDJ6415 DJ
>> 3 PKHTY8741 TY
>>
>> In Excel I used =MID(A1,4,2) at cell B1, but this formula is not
working
>> in Q Pro.
>>
>> May I know what should be the formula ?
>>
>> Thanks
>>
>> Low
>
>
> It works the same but the definition of the start is different. Use:
> @Mid(A1,3,2)
>
|
| Post Reply
|
|
|
|
|
|
|
|
|
|