Formula or Macro for adding hyphen after 5 digits
I have numerous product numbers in a single column that need a hyphen inserted after every five digits or letters. I searched google for an answer but couldn't find anything relevant to my need.
Here's an example of what I have:
7T98790005
F78G1390G8
and what I want:
7T987-90005
F78G1-390G8
Thanks.
Hi,
One way
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This might work for you. I don't know if all the data is 10 characters long so this should handle all lengths of data greater than 5 characters.
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Or
Row\Col 7T98790005 7T987-90005 B1: =REPLACE(A1, 6, 0, "-") F78G1390G8 F78G1-390G8
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks