I have a excel spreadsheet with following example
ADIS WAVEHEIGHT $ ULTRASONIC TRANSCEIVER $J/B
this is one row data, whereever there is $ sign, i want the text after that go to next line WITHIN THE SAME ROW CELL.
as i have thousands of line, can anybody suggest a way to make this work,i am...