 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006How do I separate a hyphenated word in Excel?
I have a large file of 2000 lines and I would like to make 2 columns from 1. For example: COLUMN A HEW-FA282A I would like to remove the HEW- and insert it into another (new) column and have the original column just read FA282A. Since the word is hyphenated I have been unable to find the appropriate formula. Can anyone help me? to get FA282A use: =RIGHT(A1,LEN(A1)-FIND("-",A1,1)) to get HEW use: =LEFT(A1,FIND("-",A1,1)-1) HTH > I have a large file of 2000 lines and I would like to make 2 columns from 1. > For example: [quoted text clipped - 6 lines] > have the original column just read FA282A. Since the word is hyphenated I > have been unable to find the appropriate formula. Can anyone help me? This really helped me too,thanks, another question though, what if i had 2 hyphens and needed the middle too? for example: 01DEV-XXX-thisandthat How do i get the 'inbetween' ? Thanks for any help! Keri > to get FA282A use: > [quoted text clipped - 16 lines] > > have the original column just read FA282A. Since the word is hyphenated I > > have been unable to find the appropriate formula. Can anyone help me? This really helped me too,thanks, another question though, what if i had 2 hyphens and needed the middle too? for example: 01DEV-XXX-thisandthat How do i get the 'inbetween' ? Thanks for any help! Keri > to get FA282A use: > [quoted text clipped - 16 lines] > > have the original column just read FA282A. Since the word is hyphenated I > > have been unable to find the appropriate formula. Can anyone help me? For the middle use: =MID(A1,FIND("-",A1,1)+1,FIND("-",SUBSTITUTE(A1,"-","/",1),1)-FIND("-",A1,1)-1) For the right use: =RIGHT(A1,LEN(A1)-FIND("/",SUBSTITUTE(A1,"-","/",2),1)) HTH > This really helped me too,thanks, another question though, what if i > had 2 hyphens and needed the middle too? [quoted text clipped - 24 lines] > > > have the original column just read FA282A. Since the word is hyphenated I > > > have been unable to find the appropriate formula. Can anyone help me? Toppers, thanks so much! It worked perfectly. K~ > For the middle use: > [quoted text clipped - 34 lines] > > > > have the original column just read FA282A. Since the word is hyphenated I > > > > have been unable to find the appropriate formula. Can anyone help me? Make sure column B is empty, then Highlight column A and do Data > TextToColumns > Delimited > Next > Other > type the hyphen in the little square next to Other > Next > Finish Vaya con Dios, Chuck, CABGx3 > I have a large file of 2000 lines and I would like to make 2 columns from 1. > For example: [quoted text clipped - 6 lines] > have the original column just read FA282A. Since the word is hyphenated I > have been unable to find the appropriate formula. Can anyone help me? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.