When Max said:
"Select the source col*, ...
*do ensure that adjacent cols to the right are empty first",
he meant select the COLUMN, not select an individual CELL (unless that is
the only cell you want to process).
You can either select the whole column, or select a range (within the
column) which covers all the thousands of rows which you wish to process.
--
David Biddulph

"Sajjad" wrote in message
...
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