| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I remove all text in a cell after a specific character?
I have a cell linked to an Access database field. This field contains carrage
returns. I want to display only the data before the 1st carrage return. Is there a way to do this? Perhaps useing the LEN, LEFT and other functions? BTW this is in Excle and Access 2000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ####### within a wrap text cell. | Excel Discussion (Misc queries) | |||
| advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| Forcing text onto new line in cell | New Users to Excel | |||
Threaded Mode
