tel

Hi all, Probably a really simple answer to my question. I've written the below formula to give me a tel number in a cell if one is held on another sheet and to show no tel held if it isn't there. The final part of the formula works fine but if i hold a tel number is gives me #value ! error...

Hi there, I have the below bit of code. In my head, it should loop through columns 1 to 52 of row 8 of the spreadsheet assigned to cTeam, and return True if the value is like "tel". The values in those cells are Contact Tel. Contact Tel. 2 Home Tel. Home Tel. 2 etc., but the Like operator...

Hello, im making a big database and encountered a problem, currently very new to excel (1week) and hungry to learn more. i got this text for example "TEL 14-30/11 (113-57B)1122,1123,1124,1125" and ive splittet it to 4 colums, tel 14-30/11 113-57b 1122,1123,1124,1125...

I have inheriteda list of contacts that is in an appalling state. There is almost noconsistency in the layout. In some cases all the info is in one field. Others amix of info, in rare cases properly separated. <o:p></o:p> In somecases two different contacts aqre separated by one empty row, in...