| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Left three text characters
I have a variable called "myMonth". I would like this
variable to be set to the first three text characters in cell "G3". For instance, if G3 is January, I'd like for myMonth to equal "Jan" I know that in Excel, I would have the formula be =left (D3,3). How do I put this into VB code? Thanks, Mike. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| testing for left 2 characters in set of 3 choices | Excel Worksheet Functions | |||
| Find duplicates with left 4 characters | Excel Discussion (Misc queries) | |||
| Excel 2003, SUM left-most characters | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
