opposite of concatenate

This Week's Hot Topics

• problem function date add into datepicker on userform

  • Started by abdelfattah
  • Saturday at 7:29 AM
  • Replies: 48

  hi i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i...
• Vlookup Help

  • Started by tomehta
  • May 20, 2020
  • Replies: 35

  Hello In attached excel screen shots, in Col I (sheet 1), I want Col C value (from sheet 2), similarly in Col P (sheet 1) want Col D value( from...
• Split cells based on specific text which may occur multiple times in cell

  • Started by charlie_580
  • Saturday at 8:23 AM
  • Replies: 25

  Hi I wonder if anyone can help? I need to split multiple cells by code, however the code may occur within the original cell more than once. and...
• AVERAGE RANGE CELLS DD:HH:MM FORMAT

  • Started by LawNapier
  • May 19, 2020
  • Replies: 25

  I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM". I want to only average the time for the...
• Need to color specific cells on another sheet automatically

  • Started by csteps
  • May 20, 2020
  • Replies: 23

  Need the cells listed in yellow to color those cells on another sheet automatically [ATTACH type="full"]14354[/ATTACH]
• Move Files To Dynamic Folders Based On Cell Value

  • Started by wells
  • May 19, 2020
  • Replies: 22

  Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100...