Mobile menu

How do I replace an Excel formula with the resulting text?
Thread poster: Anne Lee

Anne Lee  Identity Verified
United Kingdom
Local time: 10:20
Member (2003)
Dutch to English
+ ...
Nov 2, 2004

My two-column glossary in Excel 2003 contains some entries of terms spanning 2 rows within each column. I need to merge those entries into one row (i.e., one cell in each column) before I can order the columns alphabetically. If I simply merge the cells, the text in the second cell disappears.(I get the error message: the source cells contain multiple data. The data in the second cell will be deleted). I have found a formula for merging the text, i.e. =A2@" "@A3 for cells A2 and A3 but if I then delete the source rows, my text is also deleted. How do I 'confirm' the text in a cell so that is no longer dependent on the other cells, i.e. how do I replace the formula by the resulting text?

[Edited at 2004-11-02 15:39]


Direct link Reply with quote
 

Melissa Field  Identity Verified
Local time: 05:20
German to English
+ ...
Copy - Paste Value Nov 2, 2004

Hi Anne,

could it be as simple as Copy - Paste Special - Paste Values?

Melissa


Direct link Reply with quote
 
frentur
Turkey
Local time: 12:20
English to Turkish
+ ...
replace formula with results Nov 2, 2004

Hi Anne,

for single cell another way is to select the cell and press consecutively F2, F9 and Enter.

Best

frentur


Direct link Reply with quote
 

Anne Lee  Identity Verified
United Kingdom
Local time: 10:20
Member (2003)
Dutch to English
+ ...
TOPIC STARTER
Problem solved Nov 2, 2004

Thanks, Frentur and Melissa. The F2, F9 and Enter work a treat. Simple if you know how.

[Edited at 2004-11-05 12:35]


Direct link Reply with quote
 

Melissa Field  Identity Verified
Local time: 05:20
German to English
+ ...
good tip Nov 2, 2004

Hi Frentur,

thanks for that shortcut - it's a good one!
Melissa


Direct link Reply with quote
 

Bilingualduo  Identity Verified
Italy
Local time: 11:20
English to Italian
+ ...
I KNEW there had to be a way Nov 5, 2004

Thanks very much for this. Been trying to figure it out for years. As has been said: simple once you know.

Bambi
p.s.
I apologise in advance if this post comes out 'wrong' visually -we're working on it!
I take that back all seems well now.

[Edited at 2004-11-05 12:03]


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How do I replace an Excel formula with the resulting text?

Advanced search






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs