Cut words from a cell and paste them into columns

[Mosamba]

Hi guys,
Sorry but I have know knowledge at all about VB
In order to create a bi-lingual glossary, I'm in need of a function which must:


1. cut from column 1 and paste in column 2, the word(s) contained between the sign "=" exclusively and the sign "(" also exclusively;
2. cut also from column 1 and paste in column 3, the word(s) contained between the sign "(" inclusively, and the sign ")" also inclusively.
This operation should be repeated for approximately 1500 lines.
Should it simplify, you may generate one macro which does step 1 and another which does step 2, separately.


Appreciate very much your help.

 

[Mosamba]

You'll have to do the language conversion, but you could try these.

Extract Text

*	A	B	C	D
residual stress = tensão residual (Tensão existente mesmo após cessarem os esforços aplicados no maciço rochoso ou outro material sólido)	residual stress =	tensão residual	Tensão existente mesmo após cessarem os esforços aplicados no maciço rochoso ou outro material sólido

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:423px;"><col style="width:116px;"><col style="width:123px;"><col style="width:665px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B1 =LEFT(A1,FIND("=",A1)) C1 =TRIM(REPLACE(LEFT(A1,FIND("(",A1)-1),1,LEN(B1),"")) D1 =MID(LEFT(A1,LEN(A1)-1),FIND("(",A1)+1,LEN(A1)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Hi Override,
It was my mistake. Yes everything is working wonderfully and I've got the full spreadsheet beautifully organized. Thanks very much for all your help.
Still, what I'm actually doing is an enormous of information regarding mining terms and I'm getting these from all sorts of documents in the internet which come with different formatting. I have a problem with one of these now, which is a huge document - and requires a different solution. Would you be willing to help me with this one too, otherwise thank you for everything you managed to make me achieve. Please let me know if you may and I will post my problem. Best regards.

 

[István Hirsch]

A shorter version (if you use continental system, substitute each comma with a semicolon):

B1:

=LEFT(A1,FIND("=",A1)-2)

C1:

=SUBSTITUTE(REPLACE(A1,FIND("(",A1)-1,LEN(A1),""),B1&" = ","")

D1:

=SUBSTITUTE(A1,B1&" = "&C1&" ","")

 

[0verride]

Hi Override,
It was my mistake. Yes everything is working wonderfully and I've got the full spreadsheet beautifully organized. Thanks very much for all your help.
Still, what I'm actually doing is an enormous of information regarding mining terms and I'm getting these from all sorts of documents in the internet which come with different formatting. I have a problem with one of these now, which is a huge document - and requires a different solution. Would you be willing to help me with this one too, otherwise thank you for everything you managed to make me achieve. Please let me know if you may and I will post my problem. Best regards.

Of course you can ask another question, that's what the board is here for
If I were you I would make a new thread so other people will help you as well.
As you can see from the other replies everyone here wants to help and probably 99% knows more then I do hehe

 

[Mosamba]

Ok Override thanks indeed.
I'm going to post it as CUT AND PASTE PARAGRAPHS IN NEW LINE.

Thank you.

 

[Mosamba]

Hi István,
Appreciate your help!
Thanks very much!

 

[István Hirsch]

You are welcome.

 

[Mosamba]

I've completed the work in the spreadsheet but when I now delete column A, all other columns disappear too and in order to convert the spreadsheet to a glossary through a specific software, I need to remove Column A. Would you have a work around this?
Thanks very much!

 

[István Hirsch]

If you delete column A, columns B, C, D will disappear, therefore they should be copy/pasted somewhere else as values.
Select columns B, C and D, Copy, select the new columns where you want to put them, right-click, from the drop down menu select Paste Special, click on Values radio button, then OK.
Now you can continue processing with the other software.
Hope this helps.

 

[Mosamba]

Hi István,
It is perfect now. Thanks very much.
I've made a post titled Cut and paste paragraphs in new line, is there any chance you may help me with one?
Thanks again!