Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Ctrl F not working in Excel 2000


(!)

PincivMa's Avatar
PincivMa PincivMa is offline
Member with 319 posts.
THREAD STARTER
 
Join Date: Mar 2004
20-Jul-2012, 11:07 AM #1
Solved: Ctrl F not working in Excel 2000
Hi There

I need some explanation as to why this is happening. I copied a few rows of data from one workbook to another workbook. I then did a Ctrl F and typed in the content of the cell that I want to find in the "Find What" box. It worked OK if I did not check the "Find entire cell only" box but it could not find the contents of the cell if I checked the "Find entire cell only" box. This has me stumped. I checked the alignment, font etc and everything matched perfectly from both workbooks. I then typed in 00 132 in cell A9 did a Ctrl F and typed in 00 132 in the "Find what" box and it found the 00 132 in Cell A9 but failed to find the other 00 132 in Cell A2. Why is this happening?? I have attached both workbooks. Both workbooks are in Excel 2000.


Mario
Attached Files
File Type: xls Ctrl F not working.xls (26.0 KB, 43 views)
File Type: xls Book1.xls (15.0 KB, 23 views)
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
20-Jul-2012, 11:22 AM #2
In the Ctrl F workbook, cell A2 and A9 are not the same.

put in the formula =len(A2)
now try =lan(A9)

There is a space at the end of the number in cell A2 so it is not finding it as an exact match.
PincivMa's Avatar
PincivMa PincivMa is offline
Member with 319 posts.
THREAD STARTER
 
Join Date: Mar 2004
20-Jul-2012, 12:44 PM #3
Ok, so now I know what the problem is. I have over 50,000 rows that have an extra space a the end. How do I get rid of the extra space using a macro or formula.

Mario
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
20-Jul-2012, 03:27 PM #4
You could use clean or trim. I would probably put a formula into a blank column =trim(A1)
copy the formula down (little black box at bottom right of selected cell)
copy the column, select A1 goto edit - pastespecial - values
PincivMa's Avatar
PincivMa PincivMa is offline
Member with 319 posts.
THREAD STARTER
 
Join Date: Mar 2004
20-Jul-2012, 09:04 PM #5
Thanks, George the Trim formula worked perfectly.

Mario
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑