Splitting Text into Letters

Hi everyone.
I am having a document containing a combination of functions that will result in splitting a text into letters in different cells
Example - A2 contains Rangarajan

The result of the function will be
A3=R
A4=a
A5=n
A6=g
A7=a
and so on

Anyway i am Rangarajan.K. I want to share my knowledge in excel with every one and learn a lot from u all.

Regards
Rangarajan.K


Attached File : 15 spilting name into letters in different cells.xls downloaded: 322 times
Replies (8)

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details