For example, we have data like this
| Full Name | First Name | Last Name |
| Barack Obama | ||
| Michael Bolton | ||
| John Outlook | ||
| Cameron Diaz | ||
| Diego Maradona |
To separate values in all columns, here are the steps:
- Select all cells contain data you want to divide
- Go to Data - Text to Columns…
- Choose Delimited or Fixed Width depends on your data. In this case, we use Delimited. Next.
- Check on Space and leave the others delimiters blank. If the data contains three words, it will be separated into three columns. You may choose other delimiter, also depends on your data. Next.
- Choose the data format of separated data should be. Leave the destination by default if you want the new separated contents overwrite your original data or define new destination. Finish.
Here is the result:
| Full Name | First Name | Last Name |
| Barack Obama | Barack | Obama |
| Michael Bolton | Michael | Bolton |
| John Outlook | John | Outlook |
| Cameron Diaz | Cameron | Diaz |
| Diego Maradona | Diego | Maradona |
Next, how to join or combine contents of two cells or more into one cell?
To join or combine contents, Excel has a formula that is CONCATENATE. Concatenate is used to join several text strings into one text string. For example, we would like to rejoin the data we’ve separated on explanation above, type a formula:
=CONCATENATE([cell reference];" ";[cell reference])
Cell reference means reference of the cell you want to join. Note that you also need to add a space between two quotations so you’ll get spaced results.
Remarks: Instead of using Concatenate, the “&” operator can be used to join text items, and the formula would be:
=[cell reference]&" "&[cell reference]
example:
=A1&" "&B1
The two formulas above will give same result.
Comment please...! Read More...
