Multiple cell adjustment

[The Idea Dude]

Hi all,
I need to delete only part of the data from a lot of different cells. As in cell A3 below, I want to be able to delet 'Hair_Colour: ', so that all I am left with is a cell that contains the actual hair colour. The good news is that each row has the same thing in it ie, hair colour, or name. I will have about 30 rows to do, and about 200 columns, so I need a method that will not be real time consuming! Any Suggestions?

Thanks

Book1
	A	B	C	D
1	Name:Bill	Name:Susan
2	Hobbies:Swimming,Basketball,Sleeping	Hobbies:Reading,Study,Cycling
3	Hair_Colour:Brown	Hair_Colour:Red	etc
4	Weight_in_kg:79	Weight_in_kg:56
5
6	etc	etc
7
Sheet2

 

[PaddyD]

check out the substitute function:

=substitute(a1,"Hair_Colour:","")

Paddy

 

[Ziggy12]

as above or try edit replace Hair_Colour : with a space