|Cell A | Cell B |Cell C |
|---------------------------|----------------------------|---------------|
|Thomas Reynaud best friend |best friend Thomas Reynaud |Name |
|---------------------------|----------------------------|---------------|
|Red Pink Blue Cube |Cube Pink Blue Red | |
|---------------------------|----------------------------|---------------|
|start text end here |text start end here |Text |
|--------------------------------------------------------|---------------|
I have excel sheet with data i want to reverse words Based on conditions as i given example above in column A i have data which i need to reverse in column B based on Column C. If column C contain name in value then column A test reverse like Column B. If column C Contain empty cell then Column a value change like column B as show in my example sheet above row 2. If contain other value in column C it reverse the Column A's value like result in Column B in row 3 above.
I tried many formulas but they all work same not based on condition. mainly i tried this formula
=MID(I2&" "&I2,FIND(" ",I2)+1,LEN(I2))
and more similarly this one. Hope you understand my question thanks.
Bookmarks