| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return text in between char(10)
I have a cell with multiple instances of char(10). In one cell I want to
return the text in between the first and second instance of char(10), in the next cell I want to return the text in between the second and third instance, etc. I've been playing around with mid and substitute but can't get it to work right. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cut-off text in cell.. I want excel to cut-off the text after # of char. | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| Need Excel Function that will return # of char in preceding cell | Excel Discussion (Misc queries) | |||
| Need Excel Function that will return # of char in preceding cell | Excel Worksheet Functions | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
![Dave L[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
