---
title: "Comment by Pooja Pandey on \"Excel Tools - Fixed Width and Delimiter\" | Hashnode"
description: "Hi, I really appreciate your effort. Your article is very useful for me. I always struggle with same problem. When I compare columns using vlookup. That is form"
url: "https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45/comment/64cc3d02e7d1c7c7e11367c7"
---

[Discussion](https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45)

Comment [Excel Tools - Fixed Width and Delimiter](https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45)

[Pooja Pandey](https://hashnode.com/@P2pworkday)

[Aug 3, 2023](https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45/comment/64cc3d02e7d1c7c7e11367c7)

Hi,

I really appreciate your effort. Your article is very useful for me.

I always struggle with same problem. When I compare columns using vlookup. That is formatting error. Sometime it get resolved when I convert the format to text or I just copy the format from any XYZ files where I have already used vlookup. But some times even these tricks don't work and even after multiple try formula result will be #NA.

Can you please help me to understand the problem and how should I proceed to understand the issue... Also solution for this problem. Thanks 🙏.