Split a text or numeric string into separate cells

[benellz]

Hello All

I wonder if you could help with this one, I have a list of data like this (no spaces or other characters)

JN551122B

What I need to do is split each of the characters in to its own cell

if JN551122B was in cell A1 I'd want to return:

B2 C2 D2 E2 F2 G2 H2 I2 J2
J N 5 5 1 1 2 2 B

The nearest I have got is the right function, but it brings over the preceeding characters, and I need each character in its own cell. Hopefully I could copy/paste a formula and change the reference for each cell value, i.e. 1 would return J, 2 = N, 3 = 5, 4 = 5 etc.

Thanks for your help!

 

[Legacy 68668]

B2

=Mid($A1,Column(A1),1)

then copy to the right

 

[Gerald Higgins]

OR, use Data, Text to Columns, and specify field width as 1.

 

[netdera]

B2

=Mid($A1,Column(A1),1)

then copy to the right

what a great idea