Skip to main content

How to Split Excel Values into Two or More Columns Using Delimiter

By John Bennet
Most of us are aware of the concatenation utility support provided in MS Excel to combine two cell fields values into one. Whereas how many of us are really aware of splitting the concatenated values from a specific field into two or more fields values.

To achieve this scenario, like programming languages that use a separator called Delimiter to isolate different variables. Excel uses similar delimiter logic to separate the data values of excel cells into two or more values in different consecutive cells.

Read Also: How to Highlight Excel Search word In colors of Choice

Separate Excel Data Values of One Cell to Many Cells
Just follow the below screenshot and explanation to achieve this split cells event in Microsoft Excel.

Split Excel Values Into Several Columns
  1. Step: Select a column containing rows of data that have to be separated and then Go to Data -> Text to Columns.
    Select Values then Data - >Text to Column
  2.  Step: Select Delimited and then click on Next immediately a new wizard (Convert Text to Columns Wizard) prompts like below screenshot for configurations.
    Convert Text to Columns Wizard Step 2
  3.  Pick separators from the existing column values for Eg Mr.James Smith contains (1 dot and 1 Space as a separator and then click on Next to proceed to final configuration settings.
    Convert Text To Columns Wizard Step 2
  4. Now select column data format and Destination columns(For eg $B$2 denotes the split values resultants starting from B column 2 row) and then click on Finish.
    Convert Text To Columns Wizard Step 3
  5. And you're done, the output will list in other columns based on the number of separators used and contains in the fields as per the below screenshot.

    Output/Result
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Register and Activate SBI Internet Banking Online

By John Bennet
Internet Banking is the most trusted and efficient way of making transactions, bill payments, view accounts, view statements, deposits and many more facilities that can be accessed from any corner of the world for free. To avail these facilities in SBI (or) any  State Bank Groups new customer's will be given the PPK kit along with the passbook at the time of creating accounts in the bank itself if the internet banking facility request was mentioned in the Account opening form, but for existing customer's they have to register separately to get access to the internet banking either by visiting a branch or without visiting a branch. Also Read:   10 safety tips for secure banking online - That You Must Know If the main motive of internet banking is to ease transactions and payments for clients in the leisure, without visiting a bank home branch in person, then why not to make the registration and activation process of internet banking also in the leisure from their ...
81 comments
Read more

How to Format Write Protected USB Disk Drive and SD Card

By John Bennet
The main intention to append the write protection switches in USB flash drives and SD cards is to prevent accidental file deletion and to avoid suspicious files such as malware/trojan etc. from unauthorized sources delivering/storing into the USB disk. If the USB disk is in read-only mode, any attempts to create (or) edit file into the USB disk will be denied, But when you really want to make changes in the USB disk to add some more information (or) to edit the information that is already present in it, the restriction that you added on your computer initially will now prevent you from making changes such as adding new files or deleting existing files from any USB disk drive plugged into it. However, you can still read the files available in it, but you'll not be allowed to make changes and format the disk. The disk is write-protected -  You cannot format Having a flash drive/ SD card which is not completely accessible even by the owner of that device, is like having a l...
1 comment
Read more

How To Use USB Drive As RAM to Increase Computer Speed

By John Bennet
Note: Users running a 32bit system with 4GB Ram are advised to skip this article because 4GB is the maximum limit for a 32bit system. However, 64-bit system users can extend physical memory usage up to 512GB in Windows 8 and 192 GB in windows 7. Often your computer responds very slow after some hours of usage, it is due to overwhelming data that's being stored in your RAM since RAM is a temporary storage device it gets back to normal state after a restart, by removing entire data's that were currently stored temporarily in physical memory. USB devise as a RAM But there are several applications that require a minimum of 2GB of RAM to run, so users with low RAM capacity opt for buying an additional RAM. To avoid this you can use USB flash drive as RAM to boost your computer performance. How to Convert USB flash drive into RAM USB drives don't replicate the actual performance of the RAM(physical memory), it'll just boost the performance by increasing the t...
Post a Comment
Read more