- NEW!
by Brian on November 18th, 2009
Click on cell or column info is in. Go to Data on your tool bar then click "Text to Columns". Click radio button next to "Fixed with", then next. Click on the line where you want the breaks to be, then next. Confirm what you want to export. You can choose here to not export a part of the text you are splitting. Then click next. You must be sure that the cell to the right are clear. So if you are creating 3 columns you need 2 columns to the right open. If not, items in cells to the right will be deleted. You can add columns prior to splitting cell.
Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny on August 13th, 2011
| 1 person likes this
When I sort a list in Excel it sorts A to Z then A to Z again, not the same items, just half of it on top and half on bottom. Why?
by AndaleTheGreat on August 13th, 2011
| 1 person likes this
I need a formula in Excel that does the following..
If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011
| 2 people like this
No matter what cells I select, the freeze panes option always selects the first 15 rows to freeze. How do I fix this in Excel 2010?
by Nickname on October 8th, 2011
| 1 person likes this
I have excel 2003. I get error: The formula in this cell refers to a range that has additional numbers adjacent to it. What does it mean?.
by stretch on August 21st, 2011
| 1 person likes this
You're reading I have an excel column. Each cell contains a code similar to 16203K - I want to split the cell into 3 seperate columns to seperate the first and last characters - i.e 1 / 6203 / K Is this feasible? I am not technically gifted so simple answer appreciated
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments
That works too - and it has the advantage of getting rid of the originals, but it has the same problem as my suggestion if the codes have a variable number of digits.
by Brian I on November 18th, 2009