Thread: Extract text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Extract text
=LEFT(A1,2)
--
Gary''s Student


"Gordon" wrote:

Hi...

My minds gone blank. I used to know how to do this.

In my cell I have a post code say LA16 5TT

I just want to get the first two letters - LA and insert into adjacent cell.

Any help most welcome.


Thanks

Gordon.
Reply With QuoteReply With Quote