Hello. The problem is not a problem, but still .. I have a column with formulas that needs to be converted from a machine to values (text). I know that since 2013 there is Formulatext. How can this be solved in an older version of Excel?

XL 2007 Copies the column with formulas paste values

Yes, it's obvious, my point is that the data in one column (in which there are formulas in the rows) are automatically copied to the second, separate column (only values as text).

eg to col. D Code: textLog in, to see the code

Cool, thank you very much .. this was the solution. Best regards.

[EXCEL] Converting Formulas to Text in Older Versions: Using Formulatext Function Alternative

Reply | New topic

#1 16423800 20 Apr 2017 10:50

bystrotrecon bystrotrecon

Level 7

» |

Post #1
16423800 20 Apr 2017 10:50

Hello. The problem is not a problem, but still .. I have a column with formulas that needs to be converted from a machine to values (text). I know that since 2013 there is "Formulatext". How can this be solved in an older version of Excel?
ADVERTISEMENT
#2 16423939 20 Apr 2017 12:03

JRV JRV

VBA, Excel specialist

» | Helpful post? (0)

Post #2
16423939 20 Apr 2017 12:03

XL 2007
Copies the column with formulas

paste values
ADVERTISEMENT
#3 16423987 20 Apr 2017 12:16

bystrotrecon bystrotrecon

Level 7

» | Topic author Helpful post? (0)

Post #3
16423987 20 Apr 2017 12:16

Yes, it's obvious, my point is that the data in one column (in which there are formulas in the rows) are automatically copied to the second, separate column (only values as text).
ADVERTISEMENT
#4 16424038 20 Apr 2017 12:43

JRV JRV

VBA, Excel specialist

» | Helpful post? (+4)

Post #4
16424038 20 Apr 2017 12:43

bystrotrecon wrote:
to the second separate column ..

eg to col. D
Code: text
Log in, to see the code
#5 16428832 22 Apr 2017 15:08

bystrotrecon bystrotrecon

Level 7

» | Topic author Helpful post? (+3)

Post #5
16428832 22 Apr 2017 15:08

Cool, thank you very much .. this was the solution. Best regards.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

[EXCEL] Converting Formulas to Text in Older Versions: Using Formulatext Function Alternative

Didn't find an answer? Ask Artificial Intelligence