separate chars

  1. K

    How to separate a text in a certain column?

    Hi, I need a help in this spreadsheet: https://docs.google.com/spreadsheets/d/1oMuo868ISusPHuF28E4gci_r1umW2CnpvDIWEaUCHB8 Basically, I want a formula that will help me separate out the headings of each columns (from B1 to H1) beside each rows that has "F" character in each cells. For...
  2. Z

    How do I separate specific cell text

    Dear Excel Experts, I like your work here on mrExcel platform. I need to solve a problem. here it is. How do I separate specific cell text automtically? I have about 1000 rows like these. I need only numbers which has at the start of every cell. mark red. Please check and replay asap. thanks...
  3. Manolocs

    Joint words

    Hello, I have no idea if I can do this in Excel, I had to copy/past many pages of PDFs into a spreadsheet, so many words were past without space in between, like this.... "Mikeisgoing" "Johndoes".... should be "Mike is going" and "John does". Is there a way to fix that? Any Idea? Thanks in advance.
  4. R

    Separate Alpha and Numberic Characters

    Hi... I have a string that contains a value of Alpha and Numberic characters. How best can I break the Alpha characters from the Numberic Characters? Example: TmpValue ="Test25" Needed Result" Array(0) would = Test Array(1) would = 25 Thanks in advance for the help.

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