Thread
:
Insert colon in text in cell
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ken Johnson
Posts: n/a
Insert colon in text in cell
Hi Phoenix,
If A1 contains X12345 then =LEFT(A1,LEN(A1)-2) & ":" & RIGHT(A1,2)
pasted into any other cell will result in that cell displaying X123:45
Ken Johnson
Reply With Quote
Insert colon in text in cell