Nov 23 2021 08:00 PM
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?
Nov 23 2021 08:26 PM
=MID(A1,2,999)
=RIGHT(A1,LEN(A1)-1)