Trim function

M

Marianne

I am joining two columns of data(first and last names)
but also need to trim the blank spaces. How is this done?

example:

col1 col2
smith debra

result of join
col3
debra smith (with extra spaces)

should be
debra smith (without the extra spaces)

Thanks for your help!

Marianne
 
G

Guest

hi,
=trim(cellAddress) will trim all spaces except spaces
between words. it trims spaces at both ends of the string.
 
Top