Thread: formula for cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default formula for cell
=left(a1,30)



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
Reply With QuoteReply With Quote