View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Remove letters from text string

Hi

I run Excel 2K

I require a formula that removes the last 19 letters from a text string.

I have a number of varying lengths of text strings that require the last 10
letters being removed from each them.

Can anyone help?

Thanks

John