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
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
Continue liky, gaap na dain
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.
Very goooood
problem solved
salam::
another alternate approach.
say column a has your data. insert new temporary column B and enter below formula in b1
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.Code:=SUBSTITUTE(A1," ","")
regards
I think problem has been solved
Bookmarks