insert / into string

  1. rudogg

    Macro to Insert Colon into String

    I am in need of a macro that I can run on a selection of cells, that looks at each cell in the selection, determines if there is an existing colon in the 7th position of the string in the data, and add a second one. If there is no colon, then skip that cell. 103495:AB - would need to look...
  2. A

    Changing from message box to insertion of text into cells

    Hi, Thanks to PGC01 for the below code to show where page breaks are on a sheet. I was just looking to edit the code so that rather than the message box appearing it actually puts the text in the row itself. Something like "There is a page break on this row" in column A would do the trick I...
    • ardykav
    • Thread
    • change function insert / into string insert text
    • Replies: 3
    • Forum: Excel Questions
  3. M

    ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name."

    Hello, I apologize ahead of time if my description is too verbose :-) I have an Excel-based tool that has to regularly import data from 50+ user-selected, large CSV, XLS, and XLSX files into a single Excel workbook, and I am encountering a difficulty that would appear to be caused by Excel not...
    • misaak
    • Thread
    • adodb oledb import error import data from excel insert / into string run-time -2147467259 select / into string
    • Replies: 9
    • Forum: Excel Questions
  4. M

    Format string as date and time for time series analysis

    I want to find a way to change a string to usable date and time values so that I can run time series analyis on them. I have extracted printing records, each with "timestamps" from poster printers, but the data is unusable as it is. What I get is a string(well, thousands of them, in a column)...

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