| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking several cells into one
I am trying to have the following cells link together to look like:
RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking several cells into one
Have a look at the CONCATENATE function.
-- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "jackiel_82" wrote: I am trying to have the following cells link together to look like: RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking several cells into one
Assume B2 and C2 are text value
=CONCATENATE(A2,B2,"_",SUBSTITUTE(C2,"-","")) "jackiel_82" wrote: I am trying to have the following cells link together to look like: RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking several cells into one
Try:
=A2 & B2 & "_" & SUBSTITUTE(C2, "-", "") Regards, Greg "jackiel_82" wrote: I am trying to have the following cells link together to look like: RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking several cells into one
I'm assuming C2 is a true Excel date in the format yyyy-mm-dd
=A2&B2&"_"&TEXT(C2,"yyyymmdd") Biff "jackiel_82" wrote in message ... I am trying to have the following cells link together to look like: RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking several cells into one
If you need to get rid of the parenthesis in the cells then try =SUBSTITUTE(SUBSTITUTE(A2&B2,"(",""),")","")&"_"&S UBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"(",""),")","") ,"-","") jackiel_82 wrote: I am trying to have the following cells link together to look like: RS0001_19671109 A2(RS) B2(0001) C2(1967-11-09) is there some kind of formula i can use? Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 cells not linking | Excel Discussion (Misc queries) | |||
| Linking cells from different workbooks | Excel Discussion (Misc queries) | |||
| Linking cells with colors or highlights | Excel Discussion (Misc queries) | |||
| Excel - linking cells | Excel Worksheet Functions | |||
| linking cells colors | Excel Worksheet Functions | |||
Linear Mode
