» Separating First and Last Names Without Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
1. Select Column A or the range of cells containing the list of names.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select Delimited.
4. In Step 2 of 3, select the Space checkbox.
5. In Step 3 of 3, in the Destination box, select cell B1, and then click Finish.
Book Store:
Recommended Books:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The Analysis and Use of Financial Statements
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Business Analysis with Microsoft Excel (2nd Edition)
- Investments + S&P Card + Powerweb + StockTrak discount coupon
2 Columns To 1
Edain Posted on: 31-12-1969
Anyone know how to go the other way with this tip? I.E. Put two columns - fist name, last name together in one column.PUTTING FIRST AND LAST NAME TOGETHER
CANDY APPLE 766 Posted on: 31-12-1969
LETS SAY THE FIRST NAME IS IN CELL A1 AND THE LAST NAME IS IN CELL B1 AND YOU WANT TO PUT THEM TOGETHER IN CELL C1
IN CELL C1 TYPE =A1"& &"B1 THEN PRESS ENTER AND COPY PASTE THE FORMULA DOWN TO THE END OF THE LIST OF NAMES. AFTER HIGHLIGHT ALL THE NAMES AND RIGHT CLICK, CHOOSE COPY, THEN RIGHT CLICK AGAIN, CHOOSE PASTE SPECIAL AND CHOOSE VALUES.
Combining Two (or more) text columns
Tony Stringer Posted on: 31-12-1969
One way to combine two or more text columns is to use the CONCATENATE function. To combine the two names assuming the first name is in cell A1 and the last name is in B1, select cell C1 and type =CONCATENATE(A1," ",B1). The " " between the two cells inserts a space between the first and last name.Freezing a column
alyssa Posted on: 31-12-1969
How do I freeze a column in Excel (MS 2000) ?Freezing a column
Deanna Posted on: 31-12-1969
Put your cursor in the cell to the right of the column you want to freeze. ChooseWindow/Freeze Panes.Preventing automatic creation of columns
Ben Posted on: 31-12-1969
I have found that when I use the Text to Columns delimit feature and then later paste data Excel will automatically create columns based on the settings used previously. Is there a way to prevent this? The only way I have found is to close and reopen Excel. The problem extends across worksheets.Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
