ExcelBanter - Separate text and replace characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Separate text and replace characters (https://www.excelbanter.com/excel-worksheet-functions/236917-re-separate-text-replace-characters.html)

NBVC[_95_]

Separate text and replace characters

Try:

=LEFT(SUBSTITUTE(A1,".","-"),7)

and

=RIGHT(SUBSTITUTE(A1,".","-"),7)

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116152

All times are GMT +1. The time now is 02:18 AM.