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: 17:21
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: 12:21
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: 20:21
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: 17:21
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: 12:21
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: 18:21
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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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