J jbmahoney Board Regular Joined Jul 20, 2005 Messages 93 Nov 29, 2005 #1 Is there anyway of removing spaces at the end of cells, there is no pattern in the spaces however, some have 2, some 3, some 7. Thanks, John
Is there anyway of removing spaces at the end of cells, there is no pattern in the spaces however, some have 2, some 3, some 7. Thanks, John
G GorD Well-known Member Joined Jan 17, 2004 Messages 1,446 Nov 29, 2005 #2 Check out the TRIM function. It should do what you need
Brian from Maui MrExcel MVP Joined Feb 16, 2002 Messages 8,458 Nov 29, 2005 #3 Or ASAP Utilities www.asap-utilities.com