Find Character in Text and put value in next column
 

Hi,

I have a worksheet where in Column C has a list of Characters which
the last character will either contain a L or a R.

ie. ColumnC
125-49-0604L
125-49-0602R
125-49-0602L
125-49-0601L
125-49-0603R

I would like to put in a formula for Column D such that if the last
letter of Column C contains L then Column D = L if not then R.

I tried : if(Right(C1)="L", D1="L", D1="R" - but came up with an error
- (I would like to do this for the whole columnC. Do i specify by $C
$, $D# (???)



I would appreciate any help - thanks in advance!

Find Character in Text and put value in next column
 

One way:

=IF(RIGHT(C1,1)="L","L","R")

or, just

=RIGHT(C1,1)

In article .com,
"c8tz" wrote:

Hi,

I have a worksheet where in Column C has a list of Characters which
the last character will either contain a L or a R.

ie. ColumnC
125-49-0604L
125-49-0602R
125-49-0602L
125-49-0601L
125-49-0603R

I would like to put in a formula for Column D such that if the last
letter of Column C contains L then Column D = L if not then R.

I tried : if(Right(C1)="L", D1="L", D1="R" - but came up with an error
- (I would like to do this for the whole columnC. Do i specify by $C
$, $D# (???)



I would appreciate any help - thanks in advance!

Find Character in Text and put value in next column
 

On Feb 2, 10:11 am, JE McGimpsey wrote:
One way:

=IF(RIGHT(C1,1)="L","L","R")

or, just

=RIGHT(C1,1)

In article .com,



"c8tz" wrote:
Hi,

I have a worksheet where in Column C has a list of Characters which
the last character will either contain a L or a R.

ie. ColumnC
125-49-0604L
125-49-0602R
125-49-0602L
125-49-0601L
125-49-0603R

I would like to put in a formula for Column D such that if the last
letter of Column C contains L then Column D = L if not then R.

I tried : if(Right(C1)="L", D1="L", D1="R" - but came up with an error
- (I would like to do this for the whole columnC. Do i specify by $C
$, $D# (???)

I would appreciate any help - thanks in advance!- Hide quoted text -

- Show quoted text -

Thanks JE!!! That was all it took - I didn't specify the character
number....

thanks alot!!