This post is for personal reference but may be of some use to some people. Occasionally I export databases into Excel for work related business. One of the things which personally irks me about this process is that data which would normally be expected to appear in different columns ends up all jumbled up into one.
This tends to happen when exporting info associated with student names from the SITS database at work. So instead of getting a set of columns clearly separated by title, forename and surname I end up getting "Mr Random Person" all in one column. Not ideal if you want to arrange the data alphabetiacally by surname. Anyway, there is an easy solution to sort this mess out. I'm working with Microsoft Excel 2008 for Mac by the way.
The solution:
The solution is to delimit the selected text.
- Select the cell or column you want to split into several sections, then choose Data from the top of the screen, followed by Text to Columns to open the Convert Text to Columns Wizard.
- Excel will now ask you what kind of separation you'd like (Delimited or Fixed Width). Select Delimited, followed by Next.
- The Wizard will then present a number of division tools which may be suitable depending on the format of the text in the cells. Choose the Space or Tab options and select Next or Finish
NB: make sure you have enough space to for you columns to expand out into as Excel will overright material in the adjacent columns. Simpley insert a blank column by right clicking the cell range and selecting Insert
Not a particularly exciting or even interesting post but at least I know where to find the info as I forget every time I need to do this...
2 comments:
The best gucci replica affair about online arcade is that you do not even acquire to go anywhere to shop. Every affectionate of kids shoes in Dubai you need, is served to you in a platter. Also, you are accustomed a arrangement of options to acquire from. You can analyze anniversary account on the base of bulk and aloft and aces the one that you like the most. Online arcade makes an accustomed arcade acquaintance fun. Nowadays, women adorned all types of appearance accessories that are available. Handbags are admired asets which all ladies love, in animosity of assorted styles and designs. These action altered kinds of allowances and accomplish for a abundant appearance statement. Handbags action assurance and aegis for the requisites that a woman carries. They backpack altered kinds of items. Women adopt to bout their handbags according to the http://www.franklinnebraska.com/map.php purpose of the occasion. Although some women acquire handbags randomly, the primary aim is to advance a fashionable and altered look. All women ambition to attending adorable on any break or an event. The accident doesn't acquire to louis vuitton replica abode any dress cipher or a theme; ladies ambition to enhance their aplomb through such kinds of accessories. Artist handbags for ladies are the accepted trend and are absolutely cher as well. This commodity provides advice apropos the addition of a backpack and the ones that are must-haves. Women acquirement handbags for fashionable allowances sometimes, but added characteristics like functions; designs, styles, textures and blush variations are accordant equally. The choices differ, and actual aswell is addition aspect to consider. The capital blazon about includes claws covering handbags, hobos, and totes. Added selections are accessible in the market; however, these are the trendiest ones, accustomed the advantageous advantages. Tote handbags for women are the aboriginal blazon to breitling replica allocution about. It is absurd to abide the agreeableness of Totes. Altered types of designs, colors and styles enhance their abode to addition akin altogether. These are adapted for accoutrement collections and assorted events. Irrespective of the called apparel, analogous a tote with altered dresses is an option. Addition adorable appropriate is that a tote has abundant space, allowing the user to yield as abounding items as they wish, whenever required. Leather handbags acquire developed accepted too, and abounding admirers like the actuality that these handbags are authentic. If it comes to their selection, mediocrity is not acceptable. Women acquire the abandon to acquirement aloft products, which are admirable and durable. Covering is a acceptable best for several contest accompanying to work, parties etc. It matches with all kinds of clothing. Hobo handbags are a adequate best for ladies to aggregation up with their. The appearance and architecture is appropriate and it is fit to backpack altered items. Recently, it has affective the absorption of women due to the versatility and adequate design. Women tend to use this affectionate of a backpack on a circadian basis. They are abundantly stylish, carriageable and lightweight. Clutch handbags and purses are ideal accessories for academic contest or parties. Women can acquire from a adequate variety. They can brace them with their adopted attire. The efforts of bond accessories with an accouterments are minimal.
was not only a Replica watches UK useful device, but a necessary and proven life-saving device. More so, that the benefit of Rolex Daytona having a wrist watch style dual band PLB available was in the public interest. Replica watches Very few Swiss watches can ever claim to actually positively handbag replica serve the public interested. Despite its circa $15,000 price tag, the Breitling Replica Emegency II watch now can.In order to Replica handbags come out of the fifties up as legendary – .
Post a Comment