Converting string containing numbers and text to currency and text

I have a string with numbers and text and I want to convert the number element to currency and retain the text.

For example:

Please Login or Register  to view this content.

Needs to become:

Please Login or Register  to view this content.

Is there any easy/short way to do this?

Thanks for any help in advance!

If your data is in A1, you can use this formula (e.g. in B1):

=TEXT(--LEFT(A1,FIND(" ",A1)-1),"£#,##0") & RIGHT(A1,LEN(A1)-FIND(" ",A1)+1)

Hope this helps.

Pete

Thanks Pete - the data is actually assigned to a string variable name inside VBA but I'm sure I could adapt your technique with a bit of fiddling. Cheers.

Thanks for all the responses!

xlnitwit's was perfect for what I needed - thanks!