Prev: How do I create a feedback form?
Next: Excel password mechanism failure
From: Father John on 19 Apr 2010 18:14
`Hi
Have been working on a problem which I think I can now simplify

Cell A1 contains the following:
15 Smith Street Blacktown
How can I cut the last item (Suburb) from the cell and paste it into B1?
Many thanks in advance
Stephen
From: RagDyer on 19 Apr 2010 18:16
Try this in B1:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Father John" <w(a)b.com> wrote in message
news:oB4zn.20259$pv.9647(a)news-server.bigpond.net.au...
> `Hi
> Have been working on a problem which I think I can now simplify
>
> Cell A1 contains the following:
> 15 Smith Street Blacktown
> How can I cut the last item (Suburb) from the cell and paste it into B1?
> Many thanks in advance
> Stephen


From: John on 19 Apr 2010 18:33
Hi Father John
Have you tried >Data>Text to Columns : > Select "Fixed Width" then remove excess
line break by double clicking on them.
HTH
John
"Father John" <w(a)b.com> wrote in message
news:oB4zn.20259$pv.9647(a)news-server.bigpond.net.au...
> `Hi
> Have been working on a problem which I think I can now simplify
>
> Cell A1 contains the following:
> 15 Smith Street Blacktown
> How can I cut the last item (Suburb) from the cell and paste it into B1?
> Many thanks in advance
> Stephen

 | 
Pages: 1
Prev: How do I create a feedback form?
Next: Excel password mechanism failure