=TRIM(A1)
--
Regards,
Dave
"Nat" wrote:
> I had exported into excel some data, every cell has 15 characters if not live
> character then the system will fill it up with spaces now I want to get rip
> of the spaces but only from the spaces that the system put in to fill up the
> 15 characters not the spaces that are between the words
>
> "David Billigmeier" wrote:
>
> > What sentence are you talking about? Is that the contents of your cell? If
> > so, is the end of your sentence a period? Do you want just numerical,
> > symbols and spaces counted? Or do you want alphabetic characters counted as
> > well (e.g. A through Z)? So many questions, I am confused again what you
> > mean, sorry. Please post a couple of examples...
> >
> >
> > --
> > Regards,
> > Dave
> >
> >
> > "Nat" wrote:
> >
> > > Is there a way to count the numerical values and symbols and even spaces
> > > except the spaces after the sentence?
> > >
> > > "David Billigmeier" wrote:
> > >
> > > > Should numerical values and symbols be counted as well, e.g. should the 1,8,3
> > > > and "-" be counted in "A1FD-83"? If so all you need is =LEN(A1)
> > > >
> > > > If not you need something a little more complicated. I see you said
> > > > "alphabetical characters" so here is an example counting only the values
> > > > appearing in the English alphabet (A through Z):
> > > >
> > > > =SUMPRODUCT(--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))>=65),--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))<=90))
> > > >
> > > > If this is still not what you wanted please post some examples.
> > > > --
> > > > Regards,
> > > > Dave
> > > >
> > > >
> > > > "Nat" wrote:
> > > >
> > > > > Thank you for your reply
> > > > >
> > > > > I'm looking to calculate how much alphabetical characters I have in each cell
> > > > > "David Billigmeier" wrote:
> > > > >
> > > > > > Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
> > > > > > this formula array entered (Ctrl+Shift+Enter) will work:
> > > > > >
> > > > > > =SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
> > > > > >
> > > > > > If this isn't what you wanted try explaining a little better or posting some
> > > > > > examples.
> > > > > > --
> > > > > > Regards,
> > > > > > Dave
> > > > > >
> > > > > >
> > > > > > "Nat" wrote:
> > > > > >
> > > > > > > calculate the sum of characters in a cell
|
Similar Threads
