text & numbers in a cell

  1. K

    Code to move part of text from one cell to another?

    So my issue right now is that I'm trying to copy and paste a part of a cell's text into another cell, but for thousands of cells. It's just the format the data came in when I was exporting it from another data software (it put both the X and Y values in the same cell). All of the numbers have...
  2. K

    Text keeps formatting as date

    I know there have been lots of questions about this, but I can't seem to apply any of them to my situation and make it work. I want to copy a selection of cells from one workbook to another on a regular basis, the latter of which is a csv file. I use a script to delete the contents of the csv...
  3. D

    Formula to sum the output from DATEDIF (X Years X Months X Days)

    Hi all, I'm currently using the DATEDIF formula below to work out the diffrence between two dates contained in B242 and C242. =DATEDIF(B242,C242,"y")&" years "&DATEDIF(B242,C242,"ym")&" months "&DATEDIF(B242,C242,"md")&" days". The output displays as X years X months X days which is fantastic...
  4. W

    Get value of B7:b and E7:E (text value only) displayed on J7:j on ONE worksheet

    Ok I have the first part working with one major problem. When I run the code below it will display a text value for every page in the workbook. I only need it to display a value in "J" on the "initiating devices" page. The other pages have different column headings. Also it only will work...
  5. C

    Please help. Vlooup trouble

    Hello All, Thank you in advance for your help. Here is the problem I am having. I am trying create a table that looks at one cell reference, finds that same text in a table, and returns an Id related to the number. The cell I am referencing has both txt and numbers (ex. 123 Company, Inc.). The...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top