Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have a list as follows:
USA-- UK-- JAPAN-- I need to define a function which will return USA UK JAPAN I have tried the following but I think it needs some tweaking - thks for help Function taz(x) Dim i As Long i = InStr(x, "--") char = Trim(Left(cell, i - 1)) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
offset function in defining name | Excel Worksheet Functions | |||
Help defining a user-defined function | New Users to Excel | |||
Name Defining | Excel Discussion (Misc queries) | |||
Defining Cell namse after they are used in a function | Excel Worksheet Functions | |||
Defining | Excel Discussion (Misc queries) |