Remove first character of cell

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


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


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


    This will also remove leading and trailing spaces (even "leading" spaces that follow the "|"). -- e.g. if teh cell contained "| text" or "| text "

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!