Thread: formulae for adding a forward slash automatically into a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default formulae for adding a forward slash automatically into a cell
=LEFT(A1,3)&"\"&MID(A1,4,99)

Vaya con Dios,
Chuck, CABGx3



"angelgrant" wrote:


Hi every1,

I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

If anyone can help it would be greatly appreciated

Thanks


--
angelgrant
------------------------------------------------------------------------
angelgrant's Profile: http://www.excelforum.com/member.php...o&userid=35620
View this thread: http://www.excelforum.com/showthread...hreadid=553984


Reply With QuoteReply With Quote