| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting Parts of Cells
I have a list of information in a column. All the information has the format
of having numbers and letters then a / and more data. I only want to look at the data to the left of the /. So, I would like the data to the right of the / deleted, including the /. For example, I need YYY9/5 to read YYY9. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
