seperate characters

  1. B

    Split a string using comma and combine withput duplicates

    Hi People, Can you help me with below analysis using a VBA code. I have the sheet with below input in sheet1. It basically has two columns. Column A has ID and B has its category. an ID might have multiple lines and multiple categories each separated by comma. the possible categories are -...
  2. F

    Contact details spreadsheet...!?!

    Hi All, I have inherited a sizeable spreadsheet from a predecessor and need to clean it up to enable me to convert it to a CSV file our our CRM system. The problem is, she has entered all of the telephone numbers into one column and i need to distinguish between landlines and mobiles. Is there...
  3. E

    Split Cells based on condition

    Column A has data e.g. cat is fat xy>zzy, dog is random xyzzy, rat is a hoax.set xyz, frog is alon.23e xyz, bullseye.8 x.z I have a look up table as below Col D xy>zzy xyz x.z (Note: the values in Col D do not have a set number of characters, so I cant use a Right/left Formula) I need...
  4. K

    Diaplaying only numeric values in a cell with alpha numeric characters

    Hi, I require code for displaying only numeric values and special characters "." and "," in a particular cell which has alpha numeric characters and other special characters. For Example: Cell A1 is given a text input as "HIGH : 1,234.56", and Cell B1 is given text input as "LOWS : 1,111.22". I...

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