Left & Mid Function

[CassieL]

Hi everyone,

I hope you can help me with this.

For example:
(loop: 123) What color do you like?
(loop: 45466) What is your name?
(loop: 4114523) How old are you?

TO:

What color do you like
What is your name?
How old are you?

I like to get ride of the (loop: xxxxx) and have the question.

Your help will much appreciated and thank you!!

 

[Jonmo1]

Try

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

 

[CassieL]

Perfect!
Thank you so much!

 

[Jonmo1]

You're welcome.