Thread
: [Solved]
Insert hyphens between a string
View Single Post
02-25-2020, 01:48 AM
Marcia
Windows 7 32bit
Office 2013
Expert
Join Date: May 2018
Location: Philippines
Posts: 526
Quote:
Originally Posted by
ArviLaanemets
Like
Code:
=TEXT(A1,"00-0000-00000")
This simple? My experiments went to LEFT, RIGHT, LEN.... etc. This is the solution to my other problem of joining a data in percentage format with a text.
Thank you Arvi.
Marcia
View Public Profile
Find all posts by Marcia