Help Using Upper Function

Hi, and welcome to the forum,

I'm slightly confused since you seem to have identified the solution anyway.
i.e. with say 'Dave McGrath' in A1 then

Formula:

Please Login or Register  to view this content.

will return 'DAVE MCGRATH'

If you mean you have 'Dave' in A1 and 'McGrath' in B1 and you want both in a single cell then

Formula:

Please Login or Register  to view this content.

Please clarify your requirement.

Originally Posted by MartinR362

I want to convert both columns using the UPPER() function into all upper case text.
Martin

Do you want to combine them into 1 cell?
Do you want the conversion to be in the same cell the data is in?
As Richard says, your question is rather confusing, can you give some examples of what you have, and what you want?

Try this...

Data Range

	A	B	C	D
1
2	Martin	SMITH	MARTIN	SMITH
3	martin	smith	MARTIN	SMITH
4

This formula entered in C2:

=UPPER(A2)

Copy across to D2 then down as needed.

Seems to me that you had already answered your own question?

I want to convert both columns using the UPPER() function into all upper case text.