Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Remove first character of cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Remove first character of cell

    how do you remove the first character inside a cell?

    -its always the first
    -its always the same character, "|"

    thanks

  • #2
    Hi,

    Assuming data in cell A1 ....then in B1 type in =MID(A1,2,LEN(A1))

    HTH

    Cheers
    Stu

    Comment


    • #3
      or

      =REPLACE(A1,1,1,"")

      or

      =RIGHT(A1,LEN(A1)-1)

      where A1 is the cell with your errant value

      Take your pick
      Kind Regards, Will Riley

      LinkedIn: Will Riley

      Comment


      • #4
        Especially if the "|" occurs only that one time in each cell, you can use (for cell A2):

        =SUBSTITUTE(A2,CHAR(124),"")

        where 124 is the code for "|" (I think). You can double check by using:

        =CODE(LEFT(A2,1))
        Best Regards,
        Tom
        ---------------------------
        Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

        Comment


        • #5
          Heheee

          Love this place ... what a diverse set of solutions (& tom... that does work )
          Kind Regards, Will Riley

          LinkedIn: Will Riley

          Comment


          • #6
            You are absolutely correct, (As Always), Will. And you stimulated me to yet one more variation.

            =TRIM(SUBSTITUTE(A2,CHAR(124),""))

            This will also remove leading and trailing spaces (even "leading" spaces that follow the "|"). -- e.g. if teh cell contained "| text" or "| text "
            Best Regards,
            Tom
            ---------------------------
            Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

            Comment

            Trending

            Collapse

            There are no results that meet this criteria.

            Working...
            X