Select the range to fix
Format|Cells|Alignment tab|check wraptext

that box is the symbol for alt-enter.

If you need two separate counts, make sure the customers are in separate
cells--don't put them in the same cell separated by commas, alt-enters, spaces,
....


HoganD87 wrote:

I'm trying to seperate 2 differant names but stubborn excel keeps combining
them with this symbol Im' guessing.

I will enter

Lindab (alt + enter)
DynaTen

when I do a customer count I see:

Lindab [] DynaTen : 1 time
/|\
|
What is this box symbol??

how can I make it count each company once rather them combined as one?

No I can make a whole row for each one, that would be extremly redundant

--

Dave Peterson