how to left trim a cell......

  • Thread starter Thread starter ZoeLee
  • Start date Start date
Z

ZoeLee

Cell A1="gdhfbb:jksj"
I want Cell B1="gdhfbb", it automatically left trim A1 until it sees the
character ":"
however ":" will appear in different position, how the formula should be?
thanks

ims
 
Hi ZoeLee,

If your text is in A1 cell, try this:

=IF(ISERROR(FIND(":",A1)),A1,LEFT(A1,FIND(":",A1)-1))


HTH
 
all they work, thank you all~




Orlando Magalhães Filho said:
Hi ZoeLee,

If your text is in A1 cell, try this:

=IF(ISERROR(FIND(":",A1)),A1,LEFT(A1,FIND(":",A1)-1))


HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)
Click to expand...
 
Back
Top