How to parse comma separated values in a cell & generate command

**sirababu** · 07-17-2012, 03:55 PM

Hello all,
Column A Column B

Column C

10.50.14.1 1521, 1522, 1527

telnet 10.50.14.1 1521

telnet 10.50.14.1 1522

telnet 10.50.14.1 1527

My q is how to parse column B & generate column C, if there is only one value i can column B, i can use & or concantenate command, with multiple values i am lost

Thanks in advance for any suggestions

Babu

**zbor** · 07-17-2012, 04:26 PM

How about this:

select cell you want to work with (i.e. A19).
In B 19 is your text with ,
In C19 it will start to write result:

Please Login or Register  to view this content.

**zbor** · 07-17-2012, 04:45 PM

You can also add shortcut so you can easily run macro.
Click ALT+F8 and then select this macro and under Options button choose shortcut key (for example Shift+T)

Then you can select cell in A column and run Ctrl+Shift+T

**sirababu** · 07-17-2012, 06:42 PM

Thanks, just curious is there a formula instead of a macro.
I have multiple rows, if run it on 2nd cell, its not appending to the end of first cell generation.
Reg
Babu

**Haseeb Avarakkan** · 07-17-2012, 06:48 PM

May be like this, C1 copy down

="telnet "&A$1&" "&TRIM(MID(SUBSTITUTE(","&B$1,",",REPT(" ",99)),ROWS(C$1:C1)*99,99))

**sirababu** · 07-17-2012, 07:00 PM

Thanks, is it possible to add all telnet commands one below another in a single cell for each row.

Columna A Column B

10.50.14.1 1521, 1522, 1527
10.50.14.2 1520, 1501

Reg
Venkat

**sirababu** · 07-19-2012, 01:58 PM

Thanks, is it possible to add all telnet commands one below another in a single cell for each row.

Columna A Column B

10.50.14.1 1521, 1522, 1527
10.50.14.2 1520, 1501

Reg
Venkat