Excel: Selecting specific characters from data

[NeilPattison]

Hi everyone,

I have a list of grid references in a column in MS Excel in the form of two letters and then 4 numbers (i.e. SE4063).

I need to use a formula to select certain bits of this data(the first two letters and the 1st and 3rd numbers) which creates a grid square number (the result in this case would be SE46).

I know there is a way of doing this but my mind has gone blank.

Any help would be greatly appreciated.

 

[krispi]

if the data's in cell A4:

=LEFT(A4,3)&MID(A4,5,1)

Cheers,

Chris

 

[NeilPattison]

Thanks a lot

 

[SkipVought]

Hi,

You could also use Data > text to columns...FIXED WIDTH

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]