Forum Discussion
How to Remove First . in Cell
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
=MID(A1,2,999) =RIGHT(A1,LEN(A1)-1)
