Windows 10: HOW DO I ELIMINATE A LINE FEED WHEN ENTERING DATA INTO AN XL CELL? I WANT THE CURSOR TO...

SEE THE QUESTION ACCOMPANYING THIS: - "HOW DO I ELIMINATE A LINE FEED WHEN ENTERING DATA INTO AN XL CELL? I WANT THE CURSOR TO STAY ON THAT CELL"

:)

 

Vertical lines behind text cursor. HELP!

Hi,

It is possible that the vertical lines behind text cursor that you see, is can be due to corruptions. To better isolate your concern, kindly answer the following questions:

• Is there a way for you to provide us a screenshot?
• What troubleshooting steps have you done so far?

In the Meantime, we suggest that you follow the steps in this article by clicking on this

link. It will let you scan for corruptions and restore corrupted files.

Let us know if you need further assistance.

 

recover xls data

Hello, try making a copy of that corrupt xls file, then changing the file extension from xls to xlsx, or csv. Now try opening the file and see if the cell data is still present.

Hope this helps, and let me know!

 

Identify gaps in a sequence in one cell - Excel

Your problem can be solved by using the TREND function:

1. Taking the first data sample in Column A, you need to create 1st sequence from 1 to 13 and 2nd from 1 to 20.
   
2. Write this Array Formula in Cell C1, finish with Ctrl+Shift+Enter & fill down.
   

{=TREND(A1:A13,B1:B13,B14:B20)}

1. You get series from 14 to 20.
   
2. In D1 enter this Formula to get the 1st Cell value.
   =INDEX(C1:C7,MATCH(TRUE,INDEX((C1:C7<>0),0),0))
   
3. Enter this Formula in D2 to get last Cell value.
   

=LOOKUP(2,1/(C1:C7<>""),C1:C7)

1. In Cell D4 enter this one =D1&"-"&D2, you get 14-20.
   

Note:
For 2nd data sample you need to create 2 series.

1- 2 to 9.

2- 1 to 10.

3rd data sample needs 3 series.

1- 1 to 4.

2- 6 to 11.

3- 1 to 11.

1. Repeat the above shown steps for other data samples.
   
2. Adjust cell references in the Formula as needed.