ExcelBanter - excel question

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - excel question (https://www.excelbanter.com/excel-programming/364326-re-excel-question.html)

mudraker[_396_]

excel question

try

=LEFT(A1,3)&"."&MID(A1,4,LEN(A1)-3)

--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=552082

Justin1973

excel question

Thanks :)

"mudraker" wrote:

try

=LEFT(A1,3)&"."&MID(A1,4,LEN(A1)-3)

--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=552082

All times are GMT +1. The time now is 06:47 AM.