break the cell by words

S

Shaffiqe

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,
 
Top