| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thanks everybody for help! How to delite a part of entry for a col
Hi usmleboy,
If D2 shows 10SJ-P and E2 has =LEFT(D2,LEN(D2)-2) then in E2 you should see 10SJ, (provided Column E is not formatted as Text). You could then double click the fill handle, which is a fine cross that only appears when the fat cross cursor is positioned over the bottom right corner of the selected cell, then the formula in E2 is filled down to the bottom of your data. You could then copy column E and editpaste specialpaste values over the old values in column D. Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I work with part of a cell entry? | Excel Worksheet Functions | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| how can i fix my excel software? | Excel Discussion (Misc queries) | |||
Threaded Mode
