merge two cells into one with separator "="

Hello,

Here is my problem. I have a notepad++ file that I need to translate. Below is an example of four lines.

# Login
username = User name
password = Password
login = Login

But only the words after the = are to be translated. The words after the # signs are not to be translated.

I opened the file using excel and added a separator = . Now this is what I have : It doesn't show up, but "User name" "Password" and "Login" (on the right hand side) are all in separate cells, in colum B. Column A has the # Login/username/password/login in different lines, and lined up with Column B. (I hope I'm clear)

# Login
username User name
password Password
login Login

So this makes the translation process clear and simple, but I am worried about the reverse operation, of converting the two column format to a single column... and inserting the = sign in between...

I hope this is clear... and I hope you can help!!!
Thanks!
Cynthia

wouldnt putting them back together be (inC2)=A2&" = "&B2

So I got it, but what your formula does is puts an equal sign for all lines, whether or not they need it :

# Login =
username = User name
password = Password
login = Login

and where would I put that formula?

I forgot to say... I am a baby with Excel... just the basics

So let me get this clear. You can open the Notepadd++ file and you can get it into the format in Excel that you want?

Now you want to put it back as was, assuming you will have manipulated that data somehow,someway, so that all columns without # get concatenated with =.

If so, try this code

Sub JoinItBack()
Dim lastrow As Long
Dim i As Long

    With ActiveSheet
    
        lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
        For i = 1 To lastrow
        
            If Left$(.Cells(i, "A").Value, 1) <> "#" Then
            
                .Cells(i, "A").Value = .Cells(i, "A").Value & " = " & .Cells(i, "B").Value
                .Cells(i, "B").Value = ""
            End If
        Next i
    End With
End Sub

that is in C2

example

1----A--------B--------C
2User N-------PW-------
3fred---------1234-----=A3&" = "&B3
4bob----------5678----=A4&" = "&B4

Bob,
where do i put that code?????????

i have uploaded a sheet does this help?

merge.xlsx

Originally Posted by infact

Bob,
where do i put that code?????????

In a code module. Hit Alt-F11, goto Insert>Module and add it there. You need the Developer tab to be visible to run it.

Actually you can do an Alt-T-M-M to get to the macro list without the Developer tab.