| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a word out of two cells
I have two columns of cells: one with a 3 digit number and the other with a
name. How do I put the two together in a column so that it looks something like this: "number - name" Thanks for any help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a word out of two cells
Hi,
use =A1&" - "&B1 "Wombat" wrote: I have two columns of cells: one with a 3 digit number and the other with a name. How do I put the two together in a column so that it looks something like this: "number - name" Thanks for any help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a word out of two cells
Genius. Thanks!
"Eduardo" wrote: Hi, use =A1&" - "&B1 "Wombat" wrote: I have two columns of cells: one with a 3 digit number and the other with a name. How do I put the two together in a column so that it looks something like this: "number - name" Thanks for any help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a word out of two cells
your welcome, thanks for the feedback
"Wombat" wrote: Genius. Thanks! "Eduardo" wrote: Hi, use =A1&" - "&B1 "Wombat" wrote: I have two columns of cells: one with a 3 digit number and the other with a name. How do I put the two together in a column so that it looks something like this: "number - name" Thanks for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
| make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
| How to make (XL) Merge Cells and Word Wrap work concurrently? | Excel Discussion (Misc queries) | |||
| Make a word formula | Excel Discussion (Misc queries) | |||
| How to make cel feel like word doc | Setting up and Configuration of Excel | |||
Linear Mode
