Display Link and reordering text?

[marwan1]

Hello everyone,

Two Q's:

1-Is there an easy way to display links between sheet tabs?
2-How to rephrase the below forms from right to left and Vice versa, i:e:

Life is wonderful (inverse it)
Wonderful life (or)
Is life wonderful

Best wishes,

 

[venkat1926]

is life wonderful
is in A1 with no unnecessary spaces


try this fcrmula

="Is"&" "&LEFT(A1,SEARCH(" ",A1)-1)&RIGHT(A1,LEN(A1)-SEARCH(" ",A1,SEARCH(" ",A1)+1)+1)

 

[marwan1]

Thanks venkat1926! What is this "REF!" in your formula? Also please note that I'd like this sentence "Is life wonderful" to be read as "wonderful life" invers of the first sentence!

 

[venkat1926]

where is ref in my formula

1. have you typed "life is wonderful" in A1 or in some other cell
2. did you just copy the cell containing formula to another cell. there wil be problem because A1 will change. If you want to copy the formula as it is with no correction in cell address you should do
a) highlight formula in the FORMULA BAR and hit control+C
b) hit esc key
c) go to destination cell and hit control+V

now I am giving you the sheet

Excel Workbook
	A
1	life is wonderful
2	Is life wonderful
3	wonderful life
Sheet1

 

[marwan1]

Thanks so much, it works perfectly. Now can I apply this on long list to invert words from right to left and vice versa?