Share via

Split text which seperated by dot (.)

Anonymous
2011-05-23T09:30:04+00:00

I have in cell A1 a code of a company. There are 5-9 letters, then a dot (.) and the follow by 3-4 letters and 3-4 numbers.

Like : SUBS.ROM01.

i need to keep the full right part of the dot. so i want in cell B1 to have ROM01.

Is that possible?

Thanks in advance for your valuable time.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-05-23T09:53:46+00:00

    =MID(A1,FIND(".",A1)+1,15)

    2 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2011-05-23T23:57:52+00:00

    Hi,

    Try this

    1. Select the range and press Ctrl+H;
    2. Find for *. [start and dot]
    3. Leave the replace box blank
    4. Click on Replace All

    Hope this helps.

    0 comments
  2. Anonymous
    2011-05-23T12:44:02+00:00

    You're welcome

    0 comments
  3. Anonymous
    2011-05-23T11:57:39+00:00

    Could you mark Brad's post as 'Answer' - it will help keep others from checking to see if you need more assistance plus it adds 'Brownie points' to Brad's account.

    0 comments
  4. Anonymous
    2011-05-23T10:52:44+00:00

    Thank you very much for your help

    0 comments