Combined Functions

  • Thread starter Thread starter fncuis
  • Start date Start date
F

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,
 
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?
 
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
 
Back
Top