| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does the @ symbol do? | Excel Discussion (Misc queries) | |||
| What is this symbol? | Excel Worksheet Functions | |||
| what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
| How can you get a yen symbol? | Excel Worksheet Functions | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Linear Mode
