Thread: Add a character to the middle of a text string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default Add a character to the middle of a text string
Hi Glynn

Try
=LEFT(A1,4)&"."&RIGHT(A1,2)

--
Regards

Roger Govier


"Glynn Taylor" wrote in message
...
I need to insert a full stop between the fourth and fifth character of
a six
character string.

How do I do it?

Thank you.


Reply With QuoteReply With Quote