Results 1 to 7 of 7

Rectify wrong alignment

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    303

    Rectify wrong alignment

    Hello, I've made a mistake when writing a formula, I added a space where I shouldn't have and now all the results skewed.
    As you can see in the example, the L column is out of alignment, some cells have a space before the digits, some don't.
    I tried to fix it by formatting but it won't work.. obviously.
    I was thinking of a formula where
    IF L2 contains ("2-0", then "2-0", if not, if it contains "2-1", then "2-1", and so on with nested ifs. but I don't know what formula to use.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Wrong coding or RANDBETWEEN is wrong?
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-31-2013, 10:01 AM
  2. [SOLVED] Stock Report- help me to rectify the error
    By excuseme in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-17-2013, 04:47 PM
  3. Replies: 1
    Last Post: 02-02-2012, 11:32 AM
  4. Attendance Sheet Formula not working, please rectify it.
    By NonStopLeo in forum Excel General
    Replies: 9
    Last Post: 03-24-2010, 08:02 AM
  5. query wizard has stopped working how do i rectify this
    By Marie LND in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1