# Is there a limit to what CTRL-F can find? Newbie is confused..

#### lithnights

##### New Member
I have always used CTRL F to find certain data in cells. I often copy and paste lengthy text into a cell, sometimes many sentences or paragraphs long.

Recently i have noticed that CTRL F will not find certain data if there are too many characters in that cell.

Thus, is there a character limit for CTRL F?

e.g. the below text is in a cell and if I do a CTRL F and look for ZAG, it finds it.
If I type one extra character anywhere in that text, CTRL F will no longer find ZAG.

Does that make sense? Is there a way around this (besides putting less characters in a cell)?

Here is the text....

Using FMUSFGA.. To find any invoices that obligated large dollars.. Use account 46* through 49* but it may help to input each account as opposed to a range dollar value excluding range minus xxx to xxx Ref document 5* what shows is what we see on a given special ledger doc one can put the special ledger doc e.g. e.g. 1520661216 in the Doc number to get results ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaastuffzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz ZAG

Last edited:

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### cornflakegirl

##### Well-known Member
Just had a play - looks like a 1024 character limit, which is also the limit for display in a cell - don't know if the two are connected.

#### pgc01

##### MrExcel MVP
Hi lithnights
Welcome to the board

Where are you looking? in the values or in the formulas? If you are looking in the formulas you have the limit of the maximum length of a formula, 8192 characters in xl2007 and 1024 in previous versions.
If you search the values you don't have to worry about those limits.
Check the option in the Find window.

#### lithnights

##### New Member
Wow, you guys/gals are awesome! That's all I had to do.. in the Find options, change from Formula to Values.

Now everything changes!!! I feel a little dumb knowing it was that easy.

Thank you so much.

lithnights

Replies
10
Views
479
Replies
8
Views
624
Replies
1
Views
862
Replies
3
Views
436
Replies
3
Views
917

1,191,032
Messages
5,984,241
Members
439,879
Latest member
KingGoulash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back