0

Is there way concatenate the strings of the each paragraph in one line? For example, I have many the same paragraphs with the space between them, it looks like:

this

Is there way to put each such paragraph in one string?

This table is my desired table:

that

I placed # there with purpose to devide it further in columns in pandas, but it turned out, I need some pre-preparations for it.

Improve this question
4
  • Can you clarify how you would like to approach this problem? The question tags are excel and csv (and iptables, ignoring that), but it isn't clear what you are trying to do and where you are trying to do it. Can you add to your question what you expect the final result to look like? There are an infinite number of ways to interpret "concatenate these strings."
    – Jim Diroff II
    Commented Jul 21, 2023 at 3:39
  • I didnt want to tag iptables, i wrote table and it seems, that it was changed to iptables. I just deleted this tag. I have written my final desirable result, i dont know how to speak it in another way, but it seems you want to help, so i'll try: I want table with such rows, built from each paragraph, to devide them then with special symbol # by key words to build columns while i will parse it with pandas
    – Timur
    Commented Jul 21, 2023 at 3:54
  • At least provide some cell addresses. Which cells do you wish to concatenate into which cell? Or do you just want to strip out multiple linefeeds from the text in a given cell? Please provide some clarity.
    – Mockman
    Commented Jul 21, 2023 at 4:38
  • 1
    You could use the textjoin formula. Then if your "paragraphs" weres well-formed I guess you could do something like this: support.microsoft.com/en-us/office/…
    – gns100
    Commented Jul 21, 2023 at 14:46

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .