| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I limit what text is displayed?
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 | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| Is there a limit on amount of text that can go into a cell? | Excel Discussion (Misc queries) | |||
| Text in autoshape not displayed | Excel Discussion (Misc queries) | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
Threaded Mode
