Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating text
I have a spreadsheet where text in column of cells started repeating in each
cell. No formulas are entered in any of the cells. For example cell B3 shows descriptiondescriptiondescriptiondescription when "description" is only entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is only entered. Any ideas? -- todd fabman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating text
Have a look at the format in the cells. Is it *@ ?
Make it General best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "todd fabman" wrote in message ... I have a spreadsheet where text in column of cells started repeating in each cell. No formulas are entered in any of the cells. For example cell B3 shows descriptiondescriptiondescriptiondescription when "description" is only entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is only entered. Any ideas? -- todd fabman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating text
In xl2003 menus:
Select the cell(s) format|cells|alignment tab Change the horizontal alignment to something besides Fill. todd fabman wrote: I have a spreadsheet where text in column of cells started repeating in each cell. No formulas are entered in any of the cells. For example cell B3 shows descriptiondescriptiondescriptiondescription when "description" is only entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is only entered. Any ideas? -- todd fabman -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text with repeating trailing spaces | Excel Worksheet Functions | |||
Delete Repeating text in cells | Excel Discussion (Misc queries) | |||
searching for repeating text | Excel Worksheet Functions | |||
Text repeating on multiple worksheets | Excel Discussion (Misc queries) | |||
Repeating text in a text box within Excel. | Excel Discussion (Misc queries) |