We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

in excel how to do I convert a long name to a short name ?

TIMFOX123
TIMFOX123 asked
on
Medium Priority
267 Views
Last Modified: 2012-05-11
I have a cell
yada.nasa.gov

I want to just return "yada".

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
=LEFT(A1,FIND(".",A1,1)-1)

Assuming that the data is in Cell A1, put this formula in cell B1

Sid
AlanConsultant
CERTIFIED EXPERT

Commented:
Hard to give a general formula if you only give one single example, but how about this (yada.nasa.gov is in A1):

=LEFT(A1,FIND(".",A1&".")-1)


Alan.
AlanConsultant
CERTIFIED EXPERT

Commented:
Not trying to be pedantic, but I would just point out that the other two answers give an error if there is no "." in the string.  Unless you *want* an error in that case, best practice is to do it the way I set out.

Alan.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
But since we don't know either way... ;)

Author

Commented:
this works and saves my bacon
Thank you Tim :)

Sid
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.