Combining Data from Multiple Cells Into a single Cell

**hphemu04** · 01-06-2016, 08:53 PM

Hi team ,
Thanks for granting me access to this page .
According to the attached screenshot what i want here . excel.JPG excel.JPG .

in row 597 i have the command like in following format .

"edit ""IP_115.47.46.156""
set subnet 115.47.46.156 255.255.255.255
next "

just according to this i want all the following things ( Which is in the screenshot ) in the sequential way i.e

edit IP-115.47.52.252 (then below)
set subnet 115.47.52.252 255.255.255.255 (then below )
next

i really to not want to do all this manually .
i want this particular format for all these in same sequential manner .

how can i do this .

**alansidman** · 01-06-2016, 09:26 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**hphemu04** · 01-09-2016, 09:33 AM

I have almost 600 IP address which i need to copy and paste on a device with some specific format .

i have attached the File on which there are all the IP's on column .
Let's take the example of very first Ip 115.47.46.156 .

On the device i want this IP appears to be like following way .

edit IP_115.47.46.156
set subnet 115.47.46.156 255.255.255.255
next

and same thing i want with all rest of the IP's .

i have mentioned all the format excel file

the things which need to attention here is in the column E,F,J,K,L O .

and mainly on S and T column .

for example

i want the things which is in column J , K , L (set subnat 115.47.46.156 255.255.255.255 ) and column O (next ) in ROW 6 needs to comes right under to E and F column (edit IP_115.47.46.156 ) in next column .

Like in following way (which is in S and T )

edit IP_115.47.46.156
set subnat 115.47.46.156 255.255.255.255
next

and same thing i want for the next one which is also in column J , K , L (set subnat 115.47.52.252 255.255.255.255 ) and column O (next ) but in ROW 7 needs to comes right under to E and F column (edit IP_115.47.52.252 ) in next column .

Like in following way (which is in S and T )

edit IP_115.47.52.252
set subnat 115.47.52.252 255.255.255.255
next

The same thing i want for rest of the IP's .

and they all should be appear like in following sequential way .

edit IP_115.47.46.156
set subnat 115.47.46.156 255.255.255.255
next
edit IP_115.47.52.252
set subnat 115.47.52.252 255.255.255.255
next .

i Hope this clear the requirement that i need here .