| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Text and numbers from two cells
Hi all please help i have a cell with a number such as 6000 (a1) and another cell with a text aaa- and i would like to combine them in another cell to make aaa-6000, could somebody please help me with a formula? thanks Andrew -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=492631 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and numbers from two cells
Hi!
Try this: A1 = 6000 B1 = aaa =B1&"-"&A1 Biff "koba" wrote in message ... Hi all please help i have a cell with a number such as 6000 (a1) and another cell with a text aaa- and i would like to combine them in another cell to make aaa-6000, could somebody please help me with a formula? thanks Andrew -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=492631 |
|
#3
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and numbers from two cells
Assuming aaa- is in B1 then try:
=B1&A1 Hope this helps Rowan koba wrote: Hi all please help i have a cell with a number such as 6000 (a1) and another cell with a text aaa- and i would like to combine them in another cell to make aaa-6000, could somebody please help me with a formula? thanks Andrew |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and numbers from two cells
thanks!!!!!!!!!!!!!!!! -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 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) | |||
Linear Mode
