Blank space
in [Functions]
|
From: Dinesh on 1 Mar 2010 18:08 I have big database of customers and have blank space beoire the customer name start. How can i remove it in bunch? Dinesh
From: Slim Slender on 1 Mar 2010 19:41 On Mar 1, 6:08 pm, Dinesh <Din...(a)discussions.microsoft.com> wrote: > I have big database of customers and have blank space beoire the customer > name start. How can i remove it in bunch? > > Dinesh Save your workbook. Use the function palette to enter the TRIM function in a column to the right of the names. Enter the cell reference of the name. Drag the function down the length of the list of names. Copy all of the resulting names. Select the first cell in the original column of names. Right click and select Paste Special. Select Values only. Delete the TRIM formulas If you like the results, Save the workbook.
From: Matt Geare on 2 Mar 2010 02:53 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
From: "David Biddulph" groups [at] on 2 Mar 2010 03:54 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
From: Dinesh on 2 Mar 2010 12:26
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 > > > . > |