Easy way is to insert another column as that of the name and use find and replace to replace the space with nospace. But u need to block the column which u need to replace without space. ____,,,,_{o?o}_,,,,_____ Thanks & Regards Rajesh V -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Graham Jones Sent: Friday, January 27, 2006 05:35 To: 'mso@xxxxxxxxxxxxx' Subject: [mso] TRIM Excel function I am trying to generate fairly friendly usernames from surnames and need to eliminate spaces from between double/triple names, e.g. Mohammed Yusuf Mohammed. TRIM will only tidy any superfluous spaces, does anyone have an easy way for me to get MohammedYusufMohammed? A. Graham Jones Key Skills and IT Bellerbys College, Brighton & Hove T: 01273-323374 F: 01273-749322 E: agjones@xxxxxxxxxxxxxx www.bellerbys.com <www.bellerbys.com> ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ___________________________________________________________________________ 'Visit us at www.sundaramfinance.in' ___________________________________________________________________________ "This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM FINANCE LIMITED. As per SUNDARAM FINANCE LIMITED's policy, unencrypted mail via Internet is not considered secure". ___________________________________________________________________________ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************