Macros Excel 2007 - extracting data

Posted by Martin on Super User See other posts from Super User or by Martin
Published on 2010-09-07T19:32:12Z Indexed on 2012/09/17 9:41 UTC
Read the original article Hit count: 332

Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions?

EDIT

I have several text strings in ONE cell (a date, a part number and a color). The format looks like this 100906 PBO5 BLUE. The date is always the same number of characters but the part number could be 2, 3 or 4 characters.

I want to move the date to the position after the color so it looks like this PBO5 BLUE 100906. I have over 1,000 records so I don’t want to do this manually.

© Super User or respective owner

Related posts about microsoft-office

Related posts about excel-2007