Splitting Text into Letters

thanks! its very useful

Why go for so many complex formulaes. We can also do the same from Text to columns option available under data. Thats more simpler.

Thanks Munira for ur comments

But using text to columns is a non updating function on its own. that is it is to be repeated every time. i just wrote a formula that updates itself. see my example in PAN application. type ur name in it and it updates itself.

Regards

Rangarajan.K

Good Knowledge

Thanks Man....i was only knowing about the Text 2 Columns one

Useful info

USE FULL IN APPLICATION FILLING

THANKING YOU 

Hi everybody

I have 40,000 thousands data in that full address in Column D How to split data into address 1, address2, address 3, & city name, pin code, district, state, country, by using Text to Columns with help of VBA code.

any help Thanks,

please mail me at 

basavarajkh @ hotmail.com

Thanks

& Regards

Basavaraj K H