R
R
rmkk2020-06-08 20:39:37
excel
rmkk, 2020-06-08 20:39:37

How to chain 2 functions at once in one expression?

Can you please tell me if it is possible to perform 2 actions at once.
I want to combine text from 2 adjacent columns into a 3rd one:

=(A2& " " &B2)

and immediately convert the result to uppercase:
=UPPER(" ")


because the first time I try to work with functions in tables, I can’t figure out how to do it without an intermediate cell. I wanted something like this:
=(A2& " " &B2)=X; =UPPER("X")

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
lonelymyp, 2020-06-08
@rmkk

=UPPER(A2& " " &B2)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question