I want VBA code to convert names into first name and last name with same format please must use ranges so that i could edit them.
example is also in attached file.
Posts by ArhamRajput
-
-
Done thankyou
-
Carim,
Its not working please check. First row answer should be 749 instead of 749000
ikl;knkjnnn749.000sk 749000 ergheqrh550000sb 550000 rg100erg0000rgh 1000000 erger900000greh 900000 erg600.000rg 600000 5erger000.00ergerg 500000 fgb80000gg0rff 800000 fgwe61.000,00ewfgweg 61000 g50000f0w 500000 wef3wef1330weg 31330 gwe2300000 2300000 800000ewgweg 800000 egwweg13000wegwe00 1300000 sdg13636ghj 13636 36000sd 36000 sdg500.000 500000 sdgsdg52500 52500 -
Here is problem that after decimal it should not count number but it is please check.
749000INR 749000 shoaib550000kn 550000 1000000 1000000 900000 INR tkh 900000 Rslom 600000 kbl 600000 500000 500000 800000 800000 61.000,00 6100000 500000 500000 US $ 31330.00 3133000 2300000 2300000 800000 800000 Rs. 1300000 1300000 13636.36 1363636 INRLacs or US$36000 36000 INR 500000 500000 52500.00 USD 5250000 -
Carim,
Same question but now i want to extract ISTEXT from cell please share VBA.
-
Carim
Thank for helping me.
-
I have situation as mentioned below. I want to extract isnumber from column 1 and put in column 2 as can seen in picture.
ikl;knkjnnn749000sk 749000 ergheqrh550000sb 550000 rg100erg0000rgh 1000000 erger900000greh 900000 erg600000rg 600000 5erger00000ergerg 500000 fgb80000gg0rff 800000 fgwe6ewfgw1gweg 61 g50000f0w 500000 wef3wef1330weg 31330 gwe2300000 2300000 800000ewgweg 800000 egwweg13000wegwe00 1300000 sdg13636ghj 13636.36 36000sd 36000 sdg500000 500000 sdgsdg52500 52500 -
I have different files which are scanned documents and i want to convert that files into Excel without any extra columns, rows and spaces.
Please share VBA Code. -
Thank You Very Much
-
I have 10 files and each files contains Sheet1 how can i put these 10 files into one file as 10 sheets.
Please share VBA Code