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

G

Guest

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
 
D

Dave Peterson

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,
....

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
Click to expand...
 
D

David McRitchie

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 said:
You need to turn word wrap on. Cells/Alignment/Wrap Text Format

HoganD87 said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the "+" symbol & how do I get rid of it? 5
How do I get rid of a thing next to the cursor? 1
how do you get rid of the paragraph symbol on your documents 2
How do I get rid of this character? 2
What does this mean and how to I get rid of it? 2
How do i get rid of this? Please help!! 3
how do you get rid of seeing files with the ~ symbol? 3
How do I get rid of the copyright symbol? 7

Top