• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

quick question

M

MikeH

New Member
I am cutting domain names and using the "." as a delimiter

I need to include the delimiter in my output.

=MID(D2,FIND(".",D2&".")+1,255)

for example, this cuts myname.com into "com", but I need it to display ".com"

I'm pretty sure I just need to include a -1 somewhere in here...but I am a complete Excel newb and can not figure out where in this formula to place it.

Thanks for the anticipated help!
 
Hi Mike ,

Change your formula to :

=MID(D2,FIND(".",D2&"."),255)

Just remove the +1 which is present in your existing formula ; the FIND function will return the position where it finds the "." ; using the MID function to extract everything to the right of this point will output .com instead of com.

Narayan
 
Wow. Thats embarrassing...I guess that's what happens when you stare at code all day.. Thanks a lot.
 
You must log in or register to reply here.
Back
Top