| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting data from 2 differant colums
How do you get data from 2 differant columns to be in 1 other column.
I have a column First Name and a Column Last name I want Column Full Name to automaticlly update with the first 2 columns |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting data from 2 differant colums
Try this...
A1 = FirstName B1 = LastName Enter this formula in C1 to combine them with a space character between manes: =A1&" "&B1 Returns: FirstName LastName -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do you get data from 2 differant columns to be in 1 other column. I have a column First Name and a Column Last name I want Column Full Name to automaticlly update with the first 2 columns |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you build a chart with two differant number formats? | Charts and Charting in Excel | |||
| Auto Populate Data from cell to another sell in differant sheets | Excel Discussion (Misc queries) | |||
| Find a value in a cell and return another value in a differant cel | Excel Discussion (Misc queries) | |||
| Referancing differant sheets | Excel Worksheet Functions | |||
| Sorting merged cells of differant sizes | Excel Discussion (Misc queries) | |||
Linear Mode
