Extract text
 

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.

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.