Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
try left(your_str,InStr(your_str," ")-1) -- Regards Frank Kabel Frankfurt, Germany "JayCeeJay" schrieb im Newsbeitrag ... I am trying to manipulate incoming field info that is rather long-winded. What I wish to do is to diplay in the destination cells only the data to the Left of the first space (or break in the string). I realize it probably involves a combination of VBA functions, but I would be grateful to anyone who could help me with it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
String Manipulation within VBA | Excel Discussion (Misc queries) | |||
String Manipulation | Excel Discussion (Misc queries) | |||
VBA String manipulation | Excel Programming | |||
string manipulation | Excel Programming | |||
String Manipulation | Excel Programming |