Norika,
First create the UDF: Tools/Macro/Visual Basic/Insert/Module
Copy the code in the Module1 window
Now you find the UDF among your functions in the User defined category.
The function returns the place of the first space from the end of the string
backwards, e.g. FindRev(U13," ") returns 38
Hope it will work!
Regards,
Stefi
€˛norika€¯ ezt Ć*rta:
Stefi.
It does not work for me. Also, i dont understand your UDF(user defined
function) how to work. Would you mind to explain in details.
bpeltzer,
Using text to column function with space, it only seperates words by
words. It could not divide into two rows. Except this, is there any
ideas?
Anyway, thany you for your help.
norika
--
norika
------------------------------------------------------------------------
norika's Profile: http://www.excelforum.com/member.php...fo&userid=4878
View this thread: http://www.excelforum.com/showthread...hreadid=496595