ExcelBanter - Splitting a concatenated string into separate rows...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Splitting a concatenated string into separate rows... (https://www.excelbanter.com/excel-worksheet-functions/86864-splitting-concatenated-string-into-separate-rows.html)

Natarajan

Splitting a concatenated string into separate rows...

How can I use Excel to achieve the following

1) I wish to split a concatenated string into a column of separate characters

€œThisIsText€

should become..

€œt

h

i

s

i

s

t

e

x

t€.

2) After this I wish to display a predefined row beside every character

t €œxyz€ €œx1w€ €œ234.1w€

h €œsdf€ €œw21€ €œ12.5s€

i €œwer€ €œwe2€ €œ123.e€

..

..

..

Thank You

Natarajan Ganesan

--
Natarajan Ganesan

Richard Buttrey

Splitting a concatenated string into separate rows...

On Thu, 4 May 2006 08:19:01 -0700, Natarajan
wrote:

How can I use Excel to achieve the following

1) I wish to split a concatenated string into a column of separate characters

“ThisIsText”

should become..

Natarajan Ganesan

snipped

With A1 = "Thisistext" and B1= your predefined string named
"Yourstring"

Put the following in A3 and copy down

=MID($A$1,ROW()-2,1)&yourstring

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

All times are GMT +1. The time now is 07:20 PM.