I have many cells with descriptive text, does anyone know of a formula
where I can take for instance a cell with 500 characters and take only
the first 30 and paste it in to a new cell.

I have used a formula thanks to Gary
=left(a1,len(a1)/2

which has worked for other uses I have--now I need to extract only the
first 30 characters of a description and I have thousands of cells in
my description column..Please Help

=left(a1,30)



(E-Mail Removed) wrote:
>
> I have many cells with descriptive text, does anyone know of a formula
> where I can take for instance a cell with 500 characters and take only
> the first 30 and paste it in to a new cell.
>
> I have used a formula thanks to Gary
> =left(a1,len(a1)/2
>
> which has worked for other uses I have--now I need to extract only the
> first 30 characters of a description and I have thousands of cells in
> my description column..Please Help

--

Dave Peterson

The formula
=left(a1,30)
will take the 30 left most characters from cell A1.

Regards.

Bill Ridgeway
Computer Solutions

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have many cells with descriptive text, does anyone know of a formula
> where I can take for instance a cell with 500 characters and take only
> the first 30 and paste it in to a new cell.
>
> I have used a formula thanks to Gary
> =left(a1,len(a1)/2
>
> which has worked for other uses I have--now I need to extract only the
> first 30 characters of a description and I have thousands of cells in
> my description column..Please Help
>

Thank You Bill, thats great!
Bill Ridgeway wrote:
> The formula
> =left(a1,30)
> will take the 30 left most characters from cell A1.
>
> Regards.
>
> Bill Ridgeway
> Computer Solutions
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have many cells with descriptive text, does anyone know of a formula
> > where I can take for instance a cell with 500 characters and take only
> > the first 30 and paste it in to a new cell.
> >
> > I have used a formula thanks to Gary
> > =left(a1,len(a1)/2
> >
> > which has worked for other uses I have--now I need to extract only the
> > first 30 characters of a description and I have thousands of cells in
> > my description column..Please Help
> >

Excel HELP would have worked
LEFT Worksheet Function

try it now, as things are usually easier to find when you know
the answer, and it would help you find answers the next time.


<(E-Mail Removed)> wrote
> Thank You Bill, thats great!
> Bill Ridgeway wrote:
> > The formula
> > =left(a1,30)
> > will take the 30 left most characters from cell A1.