how do you remove the first character inside a cell?
-its always the first
-its always the same character, "|"
thanks
how do you remove the first character inside a cell?
-its always the first
-its always the same character, "|"
thanks
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 "
Don’t have an account yet? Register yourself now and be a part of our community!