merge two cells into one with separator "="

[infact]

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

[twiggywales]

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

[infact]

and where would I put that formula?

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

[Bob Phillips]

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

Please Login or Register  to view this content.

[twiggywales]

that is in C2

example

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

[infact]

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

[infact]

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

[twiggywales]

i have uploaded a sheet does this help?

merge.xlsx

[Bob Phillips]

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.

[Bob Phillips]

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