Previous in Forum: CMMS - Visual Plant   Next in Forum: Mathcad Nonlinear Second Order Differential Equation?
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
3 comments
Rate Comments: Nested
Taki R
Active Contributor

Join Date: Apr 2009
Posts: 12

Excel - Text to Columns Issue

01/11/2012 11:30 AM

Hello everyone.

I am using the text to columns function in excel, and for some reason it will not separate everything in the cell. For example the cell has "5555 Westmore St. South Bend, IN" Using text to Columns -> Deliminated -> I choose Comma -> then the destination and what I come up with is "5555 Westmore St". As you can see the state "IN" is not in a separate column.

Your help is appreciated.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Usbport
Guru
Engineering Fields - Optical Engineering - Member Engineering Fields - Engineering Physics - Member Engineering Fields - Systems Engineering - Member

Join Date: Apr 2010
Location: Trantor
Posts: 5363
Good Answers: 647
#1

Re: Excel - Text to Columns Issue

01/11/2012 11:42 AM

You might try using the text to columns feature in MS Word first, and if that works, then copy and past the columns into Excel.

__________________
 Whiskey, women -- and astrophysics. Because sometimes a problem can't be solved with just whiskey and women.
Register to Reply
SolarEagle
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#2

Re: Excel - Text to Columns Issue

01/11/2012 11:45 AM

This link will explain what I think the problem is...

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters/

__________________
 All living things seek to control their own destiny....this is the purpose of life
Register to Reply Score 1 for Good Answer
No more "Almost" Good Answers.
Taki R
Active Contributor

Join Date: Apr 2009
Posts: 12
#3

Re: Excel - Text to Columns Issue

01/11/2012 2:37 PM

I noticed that when I copy and pasted the the cells into word all the address information was on separate lines as opposed to one line as shown in the original excel file. I did a search for "^l" and replaced it with nothing and it made everything one line. I copied it back into the excel file and then i was able to separate the address into columns.

Thanks for the help.
Register to Reply
Register to Reply
Have a Different Question?
3 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

SolarEagle (1); Taki R (1); Usbport (1)

Previous in Forum: CMMS - Visual Plant   Next in Forum: Mathcad Nonlinear Second Order Differential Equation?

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (115 right now)
Show Members
Advertisement