N
N
Nikita2019-07-22 23:16:44
excel
Nikita, 2019-07-22 23:16:44

Is it possible to search in the formula bar of MS Excel?

Having a large text in a cell, is it possible to somehow search to search for text in a cell?
For example, cell A1 contains the text:
"... Eh, troika! bird troika, who invented you? know that you could only be born among a lively people, in that land that does not like to joke, but spread out evenly to half the world , and go count miles until it charges in your eyes. And not a cunning, it seems, road projectile, not captured by an iron screw, but hastily equipped and assembled you alive with one ax and a chisel by a smart Yaroslavl peasant .
In cell A2:
The coachman is not in German boots: a beard and mittens, and the devil knows what he sits on; but he got up, and swung, and dragged on the song - the horses whirlwind, the spokes in the wheels mixed into one smooth circle, the road only trembled, and the stopped pedestrian screamed in fright - and there she rushed, rushed, rushed! ..
When searching through ctrl + f values ​​quick man , excel will simply select cell A1 .
Is it possible to highlight the search result ( quick man ) also in the formula bar?
Thank you.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question