EXCEL: Truncating Text Fields to allow Vlookup searches to find da
Currently - have data set that has extra blank spaces at the end of the
fields - of varying length - what formula do you use to truncate the text fields to show only valid characters? Please don't tell me it's "truncate". -- burkeam1113 |
EXCEL: Truncating Text Fields to allow Vlookup searches to find da
On Mon, 20 Aug 2007 18:54:02 -0700, burkeam1113
wrote: Currently - have data set that has extra blank spaces at the end of the fields - of varying length - what formula do you use to truncate the text fields to show only valid characters? Please don't tell me it's "truncate". TRIM --ron |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com