u can very well use 'text to columns' option...

try these sites
http://office.microsoft.com/en-us/ex...498511033.aspx
http://forums.aspfree.com/visual-bas...ame-37434.html



"Shaffiqe" wrote:

Dear,

Please send me the formula to break/trim the words from one cell of Excel.

Example:
A B C
1 Main Road Main Road
(given) (Required) (Required)


Regards,