TIP
JOYDIP DAS wrote on December 31, 1969 19:00 EST |
| IT WAS A GREAT TIP! |
clarification needed
roomi wrote on November 30, 2005 06:32 EST |
Hi there,
I saw your tip for "reversing the word order within a string". I am not clear how it works. Can you please give a simple example to demonstrate it working.
Thanks.
My email is :
[email]born2vn2002@yahoo.com[/email] |
Reversing the Word Order within a String
Beth Morrison wrote on December 31, 1969 19:00 EST |
| Very useful -- thanks very much! |
clarification needed
born2vn2002 wrote on December 31, 1969 19:00 EST |
Hi there,
I saw your tip for "reversing the word order within a string". I am not clear how it works. Can you please give a simple example to demonstrate it working.
Thanks. |
michaelas wrote on November 30, 2005 10:41 EST |
| I could not find an example to compare the formula to. |
Clarification:
Bird wrote on November 30, 2005 10:53 EST |
Assuming two words are separated by a space in cell A1.
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))&" "&LEFT(A1,FIND(" ",A1,1)-1)
If two words are separated by a comma then a space, change the ‘-1’ to ‘-2’ before the last right-parameter. The effect is the truncation of both the ‘,’ and the space. |
Good One
Siddhanta Goel wrote on December 31, 1969 19:00 EST |
Good Tip but please clarify the use of Find function..
siddhanta_goel@yahoo.com |
alternate way
AK_Baid wrote on December 31, 1969 19:00 EST |
you can also do these by using the following
supposed the word " John is busy" is written in A1
u can reverse the order by the following formula
=mid(A1,6,2)&" "&right(A1,4)&" "&left(A,4) in B1
the answer will by "is busy John" |
alternate way
AK_Baid wrote on December 31, 1969 19:00 EST |
you can also do these by using the following
supposed the word " John is busy" is written in A1
u can reverse the order by the following formula
=mid(A1,6,2)&" "&right(A1,4)&" "&left(A,4) in B1
the answer will by "is busy John" |
I'm stumped
dharlow wrote on January 31, 2006 14:14 EST |
| I need to reverse the word order of a long list of names of varying lengths. Is this even possible or do I have to type in the formula for each one? |
A question
dharlow wrote on December 31, 1969 19:00 EST |
| I need to find a formula to reverse the word order on a long list of names of all varying lengths. Can I do this or do I have to type in the formula for each one? |
reverse the word
ranjeet patil wrote on December 31, 1969 19:00 EST |
sir,
i want to reverse the word for example - ranjeet should be teejnar.
Please tell me the formula for this and also can i use it for number of letters.
please me to ranjeethh@surferboard.com.
regards,
ranjeet |
Reversing the letters within a string
bosejav wrote on April 26, 2006 11:02 EST |
Not possible to reverse the letters in a excel worksheet function (easy in VBA of course) but you can reverse the string and store it in a formula array and then parse the formula array. For example to return the file name for a nested directory structure use the following the worksheet function:
=MID(A7,FIND(CHAR(13), SUBSTITUTE(A7,"",CHAR(13),LEN(A7)-LEN(SUBSTITUTE(A7,"",""))))+1,255)
in cell a7 if you had c:aaabbbbbcdddddfilename the above function would return filename
:) |
Reversing the order of words in each of the two-word strings in column A.
jav Bose wrote on December 31, 1969 19:00 EST |
| Not possible to reverse the order of a string and return to excel as an excel worksheet function (easy in VBA). However, you can return a formula array and then parse the array. For example to return the filename from the path 'c:aaabbbcccdddeeeeeefilename' which is stored in cell A7 do this: =MID(A7,FIND(CHAR(13), SUBSTITUTE(A7,"",CHAR(13),LEN(A7)-LEN(SUBSTITUTE(A7,"",""))))+1,255) |
Microsoft Word Version 2002 Inside Out
