| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncate Left Characters in Cell Value
I have a number of text cells and I need to be able to truncate a number of
characters from the left hand side of the value. eg. MB99_Prod_PGP_Trans needs to be truncated to "_Prod_PGP_Trans" I am having trouble trying to find the VBA code to do this. Can anyone help as I need to get this done in a hurry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to truncate text characters | Excel Discussion (Misc queries) | |||
| Excel macro - truncate cell at X characters (left to right) | Excel Programming | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
| Truncate last five characters | Excel Programming | |||
![Ray Clark[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
