-
Insert a Hyphen at two characters from the end of a String
Hi,
I have text in Column A starting at A2 as XHDIFM and as XHCRSFM.
I wish to insert a hyphen two characters from the end of each string, so the above text will look like XHDI-FM and XHCRS-FM
I have googled but get nothing close to what I want.
Can someone please offer a solution??
-
B2 and copy down.
=LEFT(A2,LEN(A2)-2)&"-"&RIGHT(A2,2)
-
Thanks Kenneth, worked like a charm
Much appreciated!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules