| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting some text from a cell
On Mon, 19 Mar 2007 12:52:36 -0400, "PCLIVE"
wrote: Here is an interesting formula that assumes there are no spaces in your printer name. This is also based on the "D" information being in cell D1. =MID(D1,FIND("printed on",D1)+11,(FIND(" ",D1,(FIND("printed on",D1)+11))-(FIND("printed on",D1)+11))) And my original would also screw up depending on where line breaks existed. I just posted a revision that takes care of that problem. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
| deleting a Text Box in a worksheet | Excel Worksheet Functions | |||
| deleting certain text from cells | Excel Worksheet Functions | |||
| Deleting 3 Text characters from the right | Excel Worksheet Functions | |||
Threaded Mode
