| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull Left & Right Text
This is probably very simple, but I need the formula for pulling characters
from the left and right of a text string. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pull Left & Right Text
On Sep 30, 5:11*pm, almostwrite
wrote: This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks! Look into MID() or RIGHT() or the LEFT() functions. RIGHT("string",4) would result in "ring" Is that what you mean? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pull Left & Right Text
myText = "Hello World"
rText = Right(myText, 5) 'Returns "World" lText = Left(myText, 5) 'Returns "Hello" mText = Mid(myText, 6, 6) 'Returns " World" "almostwrite" wrote: This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can the dwnarrow box for a pull-down list be on the left? | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| Pull-down text in a cell | Excel Worksheet Functions | |||
| Code to pull the value of a Cell of the next Worksheet to the left | Excel Programming | |||
| Help with populating a text-box with a pull-down box | Excel Programming | |||
Linear Mode
