Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need some help in a type
i have the first name o people in a row of names, and i want a type to check
if the second to last letter is "η" then write the name without the last character , if the second to last letter is "ο" then write the name with the last character changed to "υ" and if the last letter is different of the 2 above then leave the name as is.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need some help in a type
Sub checknexttolastchar()
For Each c In Selection Select Case LCase(Left(Right(c, 2), 1)) Case Is = "n": lc = "" Case Is = "o": lc = "u" Case Else: lc = Right(c, 1) End Select c.value = Left(c, Len(c) - 1) & lc Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Vatos" wrote in message ... i have the first name o people in a row of names, and i want a type to check if the second to last letter is "η" then write the name without the last character , if the second to last letter is "ο" then write the name with the last character changed to "υ" and if the last letter is different of the 2 above then leave the name as is.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need some help in a type
Hi,
here is a formula approach =IF(LEFT(RIGHT(A9,2))="n",LEFT(A9,LEN(A9)-1),IF(LEFT(RIGHT(A9,2))="o",LEFT(A9,LEN(A9)-1)&"u",A9)) where the name is in A9. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Vatos" wrote: i have the first name o people in a row of names, and i want a type to check if the second to last letter is "η" then write the name without the last character , if the second to last letter is "ο" then write the name with the last character changed to "υ" and if the last letter is different of the 2 above then leave the name as is.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert date type to text type | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) |