text from string

[Forestq]

Hi,

If in the column A I have:

Column A	ColumnB
A1: First Name: Audi	Audi
A2: Title of Book: Eliza	Eliza
A3: Last Source: Data_v3	Data_v3

<tbody>
</tbody>

how to write function, that will be inserting into column B, text afer " : " ?

 

[Jonmo1]

is there always a space after the : ?

Try

=REPLACE(A1,1,FIND(":",A1)+1,"")

 

[Forestq]

cool, works,! thank you!

 

[Jonmo1]

Glad to help, thanks for the feedback.