Remove first character of cell

Hi,

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

HTH

Cheers

or

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

or

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

where A1 is the cell with your errant value

Take your pick

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))

Heheee :lol:

Love this place ... what a diverse set of solutions (& tom... that does work )

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 "