Trim function

  • Thread starter Thread starter Marianne
  • Start date Start date
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
 
hi,
=trim(cellAddress) will trim all spaces except spaces
between words. it trims spaces at both ends of the string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset function with inconsisent data location 1
Rotate the display of a spreadsheet 2
Excel Comparing two columns 1
Change Smith, John to John Smith 4
if statement to return a list of values where answer is true 8
Header of column which has minimum in row? 1
Blank rows 2
if statement to return only true values but with out spaces 3

Back
Top