I need a strange and specific macro and excel formula! Anyone, who knows?

[excelnotknow]

Hi!

I am creating a very interesting thesaurus (words and their synonyms) for a script that I am developing!

Why I need excel, when it is in .php? Well, that's a good question!

What I need for the .php script is this format:

" A " => " B ",

where A and B are the word (A) and its synonym (B)!

Now... I need a macros or a formula that creates the whole thing! It must be:

"spaceAspace"space=>space"spaceBspace",

The spaces are very important, because without spaces, the php script WON'T WORK!

Let me illustrate it in a simpler way:

Let's say, I have the word "find" and the synonym "locate"

I want it that way:

" find " => " locate ",


I want the macro (or formula, or anything that can help... I don't know almost anything about Excel to be honest!) to make that automatically with all words, means I don't wanna add it 85000 times (the thesaurus is at least 85000 words)!

Can this be done? Or can at least be done the " A " and " B " parts with the so important SPACES?

Then, I will only have to do the "=>" part manually!!!

Can this be done? What code or macro, or formula do I need for one or any of these operations?

Please, HELP!!!

Thanks!

 

[Weaver]

If word 1 is in A2 and word 2 is in B2, try

=""""&" "&A2&" "&""""&" => " & """"&" "&B2&" "&""""

in C2

PS I suggest you copy & paste formula.

the """" (4 x ") actually adds " to a string - don't ask why, it just works!

 

[excelnotknow]

Allright... When I wrote monkey in A2 and peanut in B2, and the formula in C2, it turned into: " monkey " => " peanut "

However, I need this not only once! I need it for around 85000 words and synonyms... How can it be done.

Let's say that I paste all the *words in A and all the *synonyms in B and I have the result in C, right?


How can I do that automatically for all rows in A and B column?

 

[excelnotknow]

Allright... When I wrote monkey in A2 and peanut in B2, and the formula in C2, it turned into: " monkey " => " peanut "

However, I need this not only once! I need it for around 85000 words and synonyms... How can it be done.

Let's say that I paste all the *words in A and all the *synonyms in B and I have the result in C, right?


How can I do that automatically for all rows in A and B column?

 

[excelnotknow]

I cannot copy and paste and change the letters and numbers manually 85000 times...

 

[excelnotknow]

WOW! I just used copy>paste special>formulas and it copied the formula automatically to the other cells!!!

Thanks for the advice! Great help! Problem SOLVED!!!

 

[excelnotknow]

Only one more thing...

How can I automatically add (,) at the end of the formula?

I just forgot that!!! Sorry... The script wants it and it wants this format:


" A " => " B ",

" C " => " D ",

I mean that it needs comma after each row...

How can it be added to the formula that you provided???

 

[excelnotknow]

LOL!!! I just found help and did it alone...

The formula now looks:

=""""&" "&A2&" "&""""&" => " & """"&" "&B2&" "&""""&","

" A " => " B ",

JUST AWESOME!!!

Thanks for your help so much!!!

I have also some Ms Access issues... Are you familiar with MsAccess???