Hi,

Data|Text to columns
Select delimited
Next
Check 'Space'
Finish

Mike

"Sajjad" wrote:


How i can separate Text from Cell into other cell by space
for example
Columne A Column B Column C Column D

Mr. Muhammad Mr. Muhammad Sajjad
Sajjad

How can i do this by using excel function
--
Sajjad