James Niven
08-13-2013, 07:46 AM
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??
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??