I think this might do what you're after and allows for longer codes than 3 characters
=A1&REPT(" ",20-LEN(A1&B1))&B1
See attached file for an example, everything appears to be lined up correctly. And as Hui said it needs to be a fixed width font, such as courier.
This is sort of cheating, and not sure if useful in your case, but if i need to keep the colours without the formatting i copy and paste the table in to word, then back in to excel. I tried this on your sample file and the count formula you have seems be counting the cells with colour,though it...
wow, have been using v/hlookups daily for years, never knew they could support wild-cards, is how I first tried to solve this and then gave up!
Hats off to both of you. Many thanks.
Hi, I'm looking for a way to return a full cells value if it contains a certain character.
EG: I've a dataset where email address could be in any row from A-F and in column G I want to consolidate the emails so they are in a consistent column to later do a vlookup against
123@abc SAMPLE...