Blank space
in [Functions]
|
From: Rick Rothstein on 2 Mar 2010 14:54 On the off-chance your cells might have a combination of 1, 2, or more leading blank spaces, or even possibly some of them having no leading blank space, you can safely use this formula to perform a "left trim" on the text for all of these cases... =MID(A2,FIND(LEFT(TRIM(A2)),A2),LEN(A2)) -- Rick (MVP - Excel) "Dinesh" <Dinesh(a)discussions.microsoft.com> wrote in message news:279EBCE9-CCA5-497A-A2D1-A2D573C7C666(a)microsoft.com... > Thank you all. It works pefectly. > > Dinesh > > "David Biddulph" wrote: > >> Or =RIGHT(A1,LEN(A1)-1) ? >> -- >> David Biddulph >> >> >> "Matt Geare" <MattGeare(a)discussions.microsoft.com> wrote in message >> news:4F02AFC3-A7B5-47D8-8112-C1BFCDCC308B(a)microsoft.com... >> > Hi, >> > >> > Another approach which would avoid any unintended consequences of the >> > TRIM >> > function (TRIM will turn a double space between words into a single >> > space) >> > would be to do exactly as Slim Slender suggest but use the formula: >> > >> > =MID(A1,2,LEN(A1)) >> > >> > This will only remove the leading "space". >> > >> > Cheers, >> > >> > Matt >> > >> > "Dinesh" wrote: >> > >> >> I have big database of customers and have blank space beoire the >> >> customer >> >> name start. How can i remove it in bunch? >> >> >> >> >> >> >> >> Dinesh >> >> >> . >> |