| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
From Column A get Text from Colum B
a macro
mr=range("i22") mr.value=LEFT(mr,FIND("-",mr)-2) I believe it should be more like this... Set mr = Range("B1") mr.Offset(0, -1).Value = Left(mr.Value, InStr(mr.Value, "-") - 2) Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Programming | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
