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

[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

 

[Orlando Magalhães Filho]

Hi ZoeLee,

If your text is in A1 cell, try this:

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


HTH

 

[ZoeLee]

all they work, thank you all~

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)

 

[Bob Phillips]

ZoeLee,

Are you pasting values? If so, try selecting the Formulas option.