Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|