Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove variable text in cells
Hi,
I have a list of data that I want to edit and have tried LEFT,RIGHT & MIDDLE formulas for editing with no luck. Eg. 00123456 draft plan v.1 19-05-05 0012457 compliance plan v.2 26-06-05 012348 national business strategy v.2 07-06-05 I want to remove the date from each cell so it reads 00123456 draft plan v.1 0012457 compliance plan v.2 012348 national business strategy v.2 But because the cell characters vary and there isn't a common delimeter(-, _ .. ) I can't get excel to remove the date (last 8 digits) from the right. Any help would be greatly appreciated becuase it's driving me crazy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Format text across cells | New Users to Excel | |||
counting text cells | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) |