Hello,

I am trying to streamline my work. I am trying to apply two functions
to the same data at once. Is this possible?

1. PROPER(A1)
2. TRIM(A1)

How would I combine the above two and have the result appear in one
cell?

Thanks,


--
fncuis
------------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php...o&userid=26466
View this thread: http://www.excelforum.com/showthread...hreadid=397792

Good afternoon fncuis

Try this:

=TRIM(PROPER(A1))

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=397792

worked beautifully...


...thank you.


--
fncuis
------------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php...o&userid=26466
View this thread: http://www.excelforum.com/showthread...hreadid=397792

Does the same relative syntax apply throughout?

In other words, can I group commands like that just as long as my
parans are in place?


--
fncuis
------------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php...o&userid=26466
View this thread: http://www.excelforum.com/showthread...hreadid=397792

Hi fncuis

You're welcome. And to answer your other question, yes you can "mix
and match" all of the functions, but how easy it is depends on the
parameters. This one was easy because each function requires only one
parameter so you're asking for the result of "proper" A1 "trimmed". I
usually find it easier to write the function with the most parameters
first, and once it's working OK add the other functions to it one at a
time.

Glad you found the answer useful.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=397792