| Home > Forum Home > Automating Data Analysis Tasks > Taking out middle names on a long list of names > Trimming the content | Share |
Trimming the content
Excel Help for Trimming The Content in Automating Data Analysis Tasks
| Forum Topic | Login |
Trimming The Content | Rate this: (3/5 from 1 vote) |
 | In this case, we need to trim the content of the cell to remove any preceding or trailing spaces. The last name formula becomes: =IF(ISERROR(FIND(" ",TRIM(A2))),"",RIGHT(TRIM(A2),LEN(TRIM(A2))-FIND("*",SUBSTITUTE(TRIM(A2)," ","*",LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","")))))) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Trimming the content in the Excel Business Solutions Directory |