559942_en-US

liliconcom

How do I split text in a cell into rows without a delimiter?

I would like to split data in my rows from looking like this:

Start Letter No.	End Letter No.	Letter Sequence	Delta D
30	33	ABCD	0.065

to looking like this:

Start Letter No.	End Letter No.	Letter Sequence	Delta D
30	30	A	0
31	31	B	0.065
32	32	C	0.065
33	33	D	0.065

 

Where the sequence of letters in the text are split into a single letter in each row and this is associated with it's corresponding number in the sequence. The 'Delta D' should be 0 for the first letter in every sequence but the same number as the original row for all the other letters. I would really like a way to do this without coding so that I can do it/understand it manually.

 

Thanks!

Data Table