text from string

[Forestq]

Hi,

If in the column A I have:

[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]ColumnB[/TD]
[/TR]
[TR]
[TD]A1: First Name: Audi[/TD]
[TD]Audi[/TD]
[/TR]
[TR]
[TD]A2: Title of Book: Eliza[/TD]
[TD]Eliza[/TD]
[/TR]
[TR]
[TD]A3: Last Source: Data_v3[/TD]
[TD]Data_v3[/TD]
[/TR]
</tbody>[/TABLE]


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.