But i have to da this every time and have to be very carefull about spaces in
different rows, i have to do this work thousand of rows (Around 36000 rows)

if some formula help me
--
Sajjad


"Max" wrote:

Suggest that you try Data Text to Columns functionality
Select the source col*, then click Data Text to Columns
Choose Delimited Check "Space" Finish
*do ensure that adjacent cols to the right are empty first
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"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