Thread: How do I make excel recognize text?

"I am am trying to do some find/replaces, but for some reason I can't get Excel to recognize text formatted like this:

Piano
Vocal

i.e. if I search for "piano vocal" it won't find the above, since it has a carriage return between it. Does anyone know any Excel commands to do this so it recognizes the text that has carriage returns between it?"

ETA: Sorry

Hi fhva,
Welcome to the forum.Please take a few minutes to read the forum rules, and then amend your thread title accordingly.