How to Remove First . in Cell

Copper Contributor

Hello everyone, I need some help. I have a spreadsheet of domain names. The format looks like this: 

 

.zcsend.net
.zzzz013.xyz
.zzzz015.xyz

 

I need to remove the . in front of the domain name. I have a spreadsheet with 350 rows of these.  I only need the . in front of the domain name removed, I need the others. 

 

I'm using Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20200) 64-bit.

 

Does anyone have a clever solution to help me with this? 

2 Replies

@MollyBrown2022 

=MID(A1,2,999)

=RIGHT(A1,LEN(A1)-1)

@MollyBrown2022 

Or

=REPLACE( A1, 1, 1, "")