move part of a cell content

I need to move part of the contents of a cell (all except the last 2
chracters) to a different cell leaving the original cell as it was

i.e.

'ab1 2cd' needs to be come 'ab1 2'

after the space there is always 3 characters the first being a number
the last two are always letters

before the space the can be upto five alpha/numeric chracters

is there a way to do this please


--
slowhand
Posted from - http://www.officehelp.in

Always remove the last 2 characters?

You could use a formula like:
=left(a1,len(a1)-2)



slowhand wrote:
>
> I need to move part of the contents of a cell (all except the last 2
> chracters) to a different cell leaving the original cell as it was
>
> i.e.
>
> 'ab1 2cd' needs to be come 'ab1 2'
>
> after the space there is always 3 characters the first being a number
> the last two are always letters
>
> before the space the can be upto five alpha/numeric chracters
>
> is there a way to do this please
>
> --
> slowhand
> Posted from - http://www.officehelp.in

--

Dave Peterson

Hello
=LEFT(A1,LEN(A1)-2)

HTH
Cordially
Pascal

"slowhand" <[email protected]> a écrit dans le message de
news: [email protected]...
>
> I need to move part of the contents of a cell (all except the last 2
> chracters) to a different cell leaving the original cell as it was
>
> i.e.
>
> 'ab1 2cd' needs to be come 'ab1 2'
>
> after the space there is always 3 characters the first being a number
> the last two are always letters
>
> before the space the can be upto five alpha/numeric chracters
>
> is there a way to do this please
>
>
> --
> slowhand
> Posted from - http://www.officehelp.in
>