Combined Functions

[fncuis]

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,

[dominicb]

Good afternoon fncuis

Try this:

=TRIM(PROPER(A1))

HTH

DominicB

[fncuis]

worked beautifully...


...thank you.

[fncuis]

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?

[dominicb]

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