| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Text and numbers from two cells
If the text "aaa" is in cell b1 then type the formula below in the cell you would like to concatenate the information into. =B1&"-"&A1 Hope this helps Ed -- nuver ------------------------------------------------------------------------ nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036 View this thread: http://www.excelforum.com/showthread...hreadid=492631 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| Cells as text not numbers??? | Excel Discussion (Misc queries) | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Hybrid Mode
