Copy a cell conditionally to another in Excel

Solved
andalou82 Posted messages 8 Status Membre -  
andalou82 Posted messages 8 Status Membre -
Hello everyone,

My knowledge of Excel is not sufficient for me, I'm looking for a solution to copy a cell containing a phone number to another cell (on the same row) the file has 1500 rows (too long for copy/paste)

Description of the line:

C1 C2 C3
Address Tel: 11 11 11 11 11

If cell C2 contains: Tel: copy its content to C3

Thank you for your help.

Best regards

2 réponses

WeaponEDGE Posted messages 114 Status Membre 9
 
Hello:

In C3 you put:

=IF(C1="","";C1)
1