Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question