Pull word or words after sign /

Try this in B1 and copy down to B2

Formula:

Please Login or Register  to view this content.

Edit If the character position of the last "/" might be greater than 50 change ROW($1:$50) to something larger like ROW($1:$70)

Another way would be simpler.

Formula:

Please Login or Register  to view this content.

Dave,
what about this:

Please Login or Register  to view this content.

where I don't need to remember to change fixed values.

Eventually Ctrl+H
Replace what : */
With : (leave blank)
Replace All
Done

@ sandy666
[QUOTE]where I don't need to remember to change fixed values.
QUOTE]

Good point. Using arbitrarily large numbers has become a habit. Sometimes there's something better. Thanks for the backup.

Double posted.