The formula is easy enough to concatenate two cells into a different cell [=A1&B1]; however, I don't just want to grab the contents of A1, I want a fixed character length to be taken from A1. For example, if I have the following column information: 19850 A34587 1248 A98467 12 A87463 098342 A09844...