| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncating a string in Excel
Hi
If you always have a "-" character before the text bit and your text is in A2 then try =Trim(RIGHT(A2,LEN(A2)-FIND("-",A2))) This finds the postion of the "-", subtracts it from the length of the text (so that is the length of the word you want), then extracts that much text from the right hand side of the whole string. The trim deals with any blank space lying about. regards Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is Excel truncating my text to 255 characters? | Excel Discussion (Misc queries) | |||
| Trimming/Truncating Text Field in Excel | Excel Discussion (Misc queries) | |||
| Truncating a text string | Excel Worksheet Functions | |||
| Truncating a text string | Excel Discussion (Misc queries) | |||
| excel truncating leading zeros | Excel Programming | |||
Hybrid Mode
