Transfer partial content of a cell, line by line

[b4b7kill3r]

Hello guys,

I'm working on an indie video game that uses extensive dialog, and that requires to be translated into several languages. And I would like to know how it would be possible to copy partial content of a cell that I placed inside square-brackets, onto all the cells of the same line. That partial content also being placed at the beginning of each cell.
It would be something like this image:

Your help would be very precious, and I'll be glad to add you in the credit of my game, in exchange!

 

[Marmit424]

Hi Killer!

It sounds like part of this puzzle can be solved with concatenation, and the other part through removing the text inside the brackets using Excel's left/right/mid functions. Are you wanting the exact English words [Ran:Normal] to be at the beginning of each cell and still inside brackets? I may be able to help if that's your aim.

 

[b4b7kill3r]

Hey Marmit,
Thanks for your prompt reply.
Yes, it's exactly that: I want to have the exact English words, at the beginning of each cell of the same line, and still inside brackets.

 

[Marmit424]

This should do it for you! =CONCATENATE(LEFT(A1,SEARCH("]",A1,1)),A2) Where A1 is the first string and A2 is the new string you're bringing it to. In this case, you'd want to put this equation in a helper column after each new set of text (so A3, then A5, then A7 etc). However, if you prefer not to use helper columns, you can change the A2 out for the text itself and wrap the text in quotes "". It's a bit more work though.

If you're going to put someone in the credits please put Rick Rothstein as he's a total boss and I wouldn't know how to do that without him

 

[b4b7kill3r]

Thanks Marmit!
It works like a charm! You rock!
I'll have your name (tell me if you want your real name or just Marmit424) and Rick's name in the Credit for sure!