What is this symbol and how do I get rid of it.
 

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

What is this symbol and how do I get rid of it.
 

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

What is this symbol and how do I get rid of it.
 

You need to turn word wrap on. Cells/Alignment/Wrap Text
Format
--
Traa Dy Liooar

Jock


"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

What is this symbol and how do I get rid of it.
 

Hi Hogan,
I expect that you left out something, because if you actually typed in as
you
indicated you would have automatically have turned on cell wrap in the cell
in every Excel that I've used on Windows.

I would suggest that you turn on spell-check in your Newsgroup postings.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Jock" wrote ...
You need to turn word wrap on. Cells/Alignment/Wrap Text Format

"HoganD87" wrote:
I'm trying to seperate [separate] 2 differant [different] names but
stubborn excel [Excel] keeps combining
them with this symbol Im' [I'm] 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
[extremely] redundant