| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stripping The First Four Characters from a value
Hi,
What I am trying to figure out is how I can remove the first four characters via a VBA Macro from a value of a cell. Here's the example... Edition = ActiveCell.FormulaR1C1 (this returns a value of "Rev XA" or "Rev -" or "Rev 2") What I want the macro to do is strip the "Rev " and just keep everything from the fifth character on so I get (XA or - or 2) Any Ideas?? Thanks In Advance, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
| How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
| Formula to replace invalid filename characters | Excel Worksheet Functions | |||
| Remove varying amounts of space characters | Excel Discussion (Misc queries) | |||
| Help - Can't directly input Japanese characters into cell | Excel Discussion (Misc queries) | |||
Threaded Mode
