Hi all how do you lock a word in a cell with spaces example,
where the row 2 has the data to be entered and row 3 has the new format.
thanks
k
Excel Workbook | ||||||
---|---|---|---|---|---|---|
J | K | L | M | |||
1 | TEL:. | EXT.: | FAX: | Cel.: | ||
2 | 868-111-5212 | 1111 | 868-623-7735 | 868-111-2222 | ||
3 | Tel.: * *868-111-5212 | Ext.: * * * * * * * * * * *5555 | Fax.: * *868-623-7735 | Cell.: | ||
Sheet1 |
where the row 2 has the data to be entered and row 3 has the new format.
thanks
k