| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving out Portions of Text from a Cell.
I have this string that a customer is sending us in a report. It looks like
the following. COMPANY NAME; NAME; 11/22/04 I wanted to use the Text to Column feature, but every cell varies in length and amount of data. I am curious if there is a way to search the cell and strip out the date out of each cell and move them into a different cell on the same row. Or can I setup a macro to copy the entire column, and then strip out everything but the date. Any information that could be provided would be greatly appreciated. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract portions of text | Excel Worksheet Functions | |||
| Conditional functions on portions of cell data | Excel Worksheet Functions | |||
| Row & column portions of a cell as variables | Excel Discussion (Misc queries) | |||
| Change font in portions of cell with many characters (1000's) | Excel Discussion (Misc queries) | |||
| How do I truncate or hide portions of text in a pivot table? | Excel Worksheet Functions | |||
Threaded Mode
