ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   words in cell keep repeating (https://www.excelbanter.com/excel-discussion-misc-queries/237808-words-cell-keep-repeating.html)

Hyde Park

words in cell keep repeating
 
In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens

John[_22_]

words in cell keep repeating
 
Hi
Are you importing information from the internet ?, I'm getting the same thing
but only from my bank account import,
I did ask the same question few months ago but never got a reply.
Hoping someone has a answer.
Regards
John
"Hyde Park" <Hyde Park @discussions.microsoft.com wrote in message
...
In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens



Jim Thomlinson

words in cell keep repeating
 
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


John[_22_]

words in cell keep repeating
 
Hi Jim
"You're the man", it solved my problem, hope it's the same for Hyde Park
Many thanks....
Regards
John
"Jim Thomlinson" wrote in message
...
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens



[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 12:13:01 PM UTC-4, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


Thank you!!! This fix just saved my file.

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 9:43:01 PM UTC+5:30, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


thanks man you saved my day (internship) :)

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 11:13:01 AM UTC-5, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


You are the bomb.com

[email protected]

words in cell keep repeating
 
Thank you Jim, this solution worked.

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 9:13:01 AM UTC-7, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


Saved my life!

[email protected]

words in cell keep repeating
 


I think we can all agree that JIM is awesome, and has been saving people for a decade now!

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 12:13:01 PM UTC-4, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


Thank you Jim!

[email protected]

words in cell keep repeating
 
Hi Can someone help me please i have two rows that are connected. what i type in one row then goes into the cell below.

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 12:13:01 PM UTC-4, Jim Thomlinson wrote:
Probably a Fill format.

Format - Format Cells... | Alignment (tab)| Horizontal (drop down)

As a guess this is set to Fill which repeats the text in the cell. Change it
to Indent Left.
--
HTH...

Jim Thomlinson


"Hyde Park" wrote:

In a worksheet that has been created and that we used repeatedly in our
business, one cell keeps repeating the name we are placing in it. Such as we
type the name Wolf, J and when you hit enter the cell contains Wolf, J Wolf,
J Wolf, J there is no formatting for this cell and I have deleted
everything in it and try again and it still happens


Still saving the day, thanks Jim!

[email protected]

words in cell keep repeating
 
Jim saves the day!

[email protected]

words in cell keep repeating
 
On Thursday, July 23, 2009 at 11:07:01 AM UTC-4, Park @discussions.microsoft.com Hyde Park wrote:
Inmatting for this cell and I have deleted
everything in it and try again and it still happens




All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com