hyphens

  1. P

    Insert dashes within character string, within an array.

    ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array. For example... Column Z contains the following list of values: MSEAVIMA0013S MSEAVIRM0016S MOLPVIRM0017S MOLS130012S MSEAVIRM0011S...
  2. O

    Extracting string between 2 characters

    <tbody> Account Object code Description 001 -111141- 001 -14559 - 001 -99-01-X -121-00-54080 - 001 -99-04-X -122-73-5L010 - 001 -02-02-X -152-00-56133 - </tbody> I am looking to extract the string between the 2 last hyphens. For example, i need to extract the object...
  3. S

    Reformatting Strings

    I would like to be able to reformat a date string in a workbook. The strings are in the format "15-Feb-08" for instance and I would like to have them read "02/15/2008". How can I use the hyphens as the basis to separate date components and reconstruct the date in a different format? Thanks
  4. C

    Joining text with hypen separator

    Hi all, I am currently using CONCATENATE(AR3,"/",AS3) to join text, but the end result looks like (Black/ Rust). Is there anyway to bring that Rust in a little bit? I have also tried (AR3&"/"&AS3), but it still keeps the word "Rust" about one space too far to the right. I have tried with no...
  5. kelly mort

    Changing date format to custom format and maintaining data structure

    I just got myself into a trap and I am looking for ways to get out. I have entered dates as dd-mm-yy into cells in my database. I want to remove those hyphens and have something like ddmmyy. Then I noticed that whenever I remove the hyphens, it converts the new number in the cell into a...
  6. B

    Concatenate 2 cells and separate with 2 hyphens

    Ok my friends, i have searched for concatenating 2 cells with hyphens and have found several solutions. I cannot however see what it is that i am after. I would like to concatenate 2 values e.g 2453 in cell 1 and 987654321 in cell 2. I have seen how to do the first hyphen using...
  7. C

    Textbox First Name

    - I have a Userform that contains a Textbox where an applicant enters their first name - Some applicants use two names in their first name with no hyphen (e.g. "Rose Ann") Question - I want the textbox to kick out spaces prior and following the name - I also want to remove double or more spaces...
  8. R

    Conditional Formatting on Three Dashes / Hyphens

    Hello, I'm trying to conditional format three dashes / hyphens "- - -" that are the result of formulas. I can't seem to get a conditional format to work on this. Does anyone have any ideas? RB

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