Thread: extact text string from specific cell except three last characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default extact text string from specific cell except three last characters
Try this:

=LEFT(A1,LEN(A1)-3)

Hope this helps.

Pete

On Oct 23, 2:08 pm, "markx" wrote:
Hi guys,

Is there any formula in excel that will extract me all the text from a
string except three last caracters?
Thanks a lot in advance for your help on this,

Rgds,
Mark


Reply With QuoteReply With Quote