Text to columns

[mmmarks]

Hi All,

I have an query regarding Text to columns
I have a sequence like AATGACGATAGA.
I want each letter in different Cell respectivly...
Let In Cell A1 "A", In Cell B1 "A". In Cell C1 "T" so on...

It can be done through Text to Column.. If there is 10 or 20 letters its ok..
But I have more than 200 letters.
Is there any short cut.. or any formula to split them all in different cell


Thanks In advance..

 

[Jonmo1]

You can use a formula...

Say your sequence is in A2

In B2, put

=MID($A2,COLUMNS($A2:A2),1)

And fill right as far as needed


Hope that helps.

 

[mmmarks]

Yahooooooooooooooooooooooooooo!!

Its works

Thanks a Lot!!!!

 

[Jonmo1]

Glad to help, thanks for the feedback.