| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
single text cells combines in new text cell
I have searched and searched for what I believe is really simple formula, but either I dont know what to search for or what I want to do is so elementary it should just be know. Anyway here is what I need to do. a1=tom a2=smith a3="that car belongs to ";a1;a2 I need this to be universal so the formula works on column 3 of any row and will give me the result for that row. Anybody have a link or suggestion Carter -- toad32 ------------------------------------------------------------------------ toad32's Profile: http://www.excelforum.com/member.php...o&userid=24090 View this thread: http://www.excelforum.com/showthread...hreadid=376965 |
|
#2
|
|||
|
|||
|
One way:
C3: ="that car belongs to " & A1 & " " & A2 In article , toad32 wrote: I have searched and searched for what I believe is really simple formula, but either I dont know what to search for or what I want to do is so elementary it should just be know. Anyway here is what I need to do. a1=tom a2=smith a3="that car belongs to ";a1;a2 I need this to be universal so the formula works on column 3 of any row and will give me the result for that row. Anybody have a link or suggestion Carter |
|
#3
|
|||
|
|||
|
And just to add to J.E.'s response...
If you have dates or times or money that needs to be formatted: ="that car belongs to " & A1 & " " & A2 & " and cost " & text(a3,"$#,##0.00") & " when they bought it on: " & text(a4,"mm/dd/yyyy") & "." toad32 wrote: I have searched and searched for what I believe is really simple formula, but either I dont know what to search for or what I want to do is so elementary it should just be know. Anyway here is what I need to do. a1=tom a2=smith a3="that car belongs to ";a1;a2 I need this to be universal so the formula works on column 3 of any row and will give me the result for that row. Anybody have a link or suggestion Carter -- toad32 ------------------------------------------------------------------------ toad32's Profile: http://www.excelforum.com/member.php...o&userid=24090 View this thread: http://www.excelforum.com/showthread...hreadid=376965 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
| city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| Text is not showing up in cell. Why not? | Excel Discussion (Misc queries) | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Linear Mode
