Excel 2007: Seperating text with a . (dot) in a cell?

I have a spread sheet with FQDN's in one column. What I need to do is separate it so that I only have the short name.

So this is currently in column1

I need it to be....
Column1   Column2
PC                 domain.com

Is there a way to automate this to make it easier to do?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

barry houdiniConnect With a Mentor Commented:
If data is in A2 you can use these formulas in B2 and C2 to split



formulas can be "filled down" the column for multiple rows

regards, barry
SteveConnect With a Mentor Commented:
You can do Data tab, then Text to column

REIUSAAuthor Commented:
Thank you, both suggestions work great.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.