Re: can I execute and 'substring' function in Excel
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 1 Jan 2006 11:04:45 -0000
Larry@xxxxxxxxxxxxxxxxxxxxxxxxx <Larry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>>> I have a cell that I need to fiding out what the 1st two characters
>>> in the cell are AND then put a related character in another column.
>>> Can I do this in Excel??????
>>> --
>>> Larry
Hi Larry
Thanks for the feedback.
I'm still not sure what you were actually trying to achieve, but if my
pointers helped then that's good.
Happy New Year to you also.
--
Regards
Roger Govier
Larry <Larry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Roger,
> Thanks a bunch. I've spent about 8 hours trying different functions
> without any success. The three functions you gave me all worked but I
> had to use =CODE and wrap it in an =IF statement so I could add the
> column.
> I will be sure to use this site more often.
> Absolutely a great job!
> Happy New Year!
> --
> Larry
>
>
> "Roger Govier" wrote:
>
>> Hi Larry
>>
>> =LEFT(A1,1) will return the first character within cell A1
>> as will =MID(A1,1,1)
>> =MID(A1,2,1) will return the second character.
>>
>> =CODE(MID(A1,1,1)) will return the ASCII code number of the first
>> character
>>
>> I hope that this will get you started.
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Larry" <Larry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
.
- Follow-Ups:
- Prev by Date: Re: Standard Deviation
- Next by Date: Re: Networkdays & future months
- Previous by thread: Re: Standard Deviation
- Next by thread: Re: can I execute and 'substring' function in Excel
- Index(es):
Relevant Pages
|
