text alignment formula

  1. M

    need help organizing random cells

    ok so I'm trying to organize some data but when i paste it from elsewhere i can post it but I can't seem to find a way to organize it. I ave to do hundreds of these and I'd prefer to not do it all by hand so if anyone knows a way of organizing these with a formula that would be marvelous! this...
    • Miguel1598
    • Thread
    • formula & text organization text alignment formula text and numbers
    • Replies: 4
    • Forum: Excel Questions
  2. D

    help removing character from text string

    Hello! I am needing assistance with the following issue. I have a string of text where the 8th character is always a "-" but the amount of characters that follow are different. ex: amcc-ap-h-d amcc-ar-h amcc-as-h-d-a i need to remove the 8th character from each to return the following...
  3. R

    Text Alignment Formula

    Hello: When I add the same text to the end of two words that have the same length, they do not look aligned even though the length is the same: PHOTOCOPIERS OK SHREDDERS OK How can I align them using a formula so that OK in the second cell end at the same spot 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