Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, just incase you are trying to do this in VBA you may want to try
the following--'Find' doesn't get it done in the VBA editor(at least not mine--Office 2003). The above examples work great as a worksheet formulas. Option Explicit Sub conc_names() Dim myVariable$, myCellValue$ myCellValue = Cells(1, 1) myVariable = Left(myCellValue, 1) & Mid(myCellValue, InStr(1, myCellValue, " ", 1) + 1, 1) End Sub HTH--Lonnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Frustrating SUMPRODUCT problem. | Excel Discussion (Misc queries) | |||
IRR, XIRR and NPV - a very frustrating problem | Excel Discussion (Misc queries) | |||
Very Frustrating - Please Help! | Excel Worksheet Functions | |||
Frustrating Problem | New Users to Excel | |||
Bizarre and frustrating bug | Excel Programming |