Excel Mai Help Chahiye

[ovaise]

Please Maire ko Ye batade ke Maine aik Cell Mai
(878787 1) Likha hai maire ko Ye Gap Khatam karna hai Dirmian se
Yani 1 se Pehle

[Sameer Jee]

Continue liky, gaap na dain

[sayhellotoit]

Iss poray column ko aik nayi Excel file mein paste karian
aur Crtl H press karain (ya Edit menu say Replace select karain.)



Find what mein Space bar press karain
Aur Replace All button ko click karain.

[ovaise]

Very goooood


problem solved

[syar]

salam::

another alternate approach.
say column a has your data. insert new temporary column B and enter below formula in b1

=SUBSTITUTE(A1," ","")

copy down as far as required. after getting desired result select your column B and copy it. then edit paste special--->tick values your fomula change into value.
regards

[Rashid__Farooq]

I think problem has been solved