Moving part of a cell contents to the next column

[anch-innk]

Hello everyone!
I class myself as an Excel novice but generally able to cope with PC stuff, having used computers since the 1980s. However, I have managed to skirt round programming macros etc. in Excel, which I now regret. As a translator, I often need to process glossaries provided by customers, colleagues etc. before reading them into my translation software. In the present case, I have a situation similar to ones discussed here but with a twist. I have entries like:

A24: remove material (manually)
A36: relax (pressure increase, prestress)

and all I want to do is shift everything in parentheses to the next column.

A24: remove material B24: (manually)
A36: relax B36: (pressure increase, prestress)

I can then just delete all the parentheses in column B and bob's your uncle. Those entries are then used to create definitions in the translation software.
Many of the cells in column A do not have any parentheses.

A. I don't know (yet) how to adapt the answers provided here to do that
B. What on earth does one do with the formula when one has it? Copy it into each of the 51255 rows in the table? (Yes, it's a big one!).

I would appreciate some assistance!

[AliGW]

Look at the Text to Columns feature using your opening bracket as the delimiter.

https://support.microsoft.com/en-us/...a-7a3e9c363ed7

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[anch-innk]

Crikey, AliGW!
That's got it sorted in no time! Amazing and many thanks.
Excel is probably the one Microsoft product that is just unbeatable. It is so incredibly powerful - one just needs to be pushed in the right direction to experiment with its on-board functionality.

Regards again from (now sunny) Germany!
ANCH

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[anch-innk]

Hi again
That was the next point for me - to mark as solved. Now I know how...
I've already added a comment to your reputation ;-)