---
title: "Discussion on \"Excel Tools - Fixed Width and Delimiter\" | Hashnode"
description: "Discussion on \"Excel Tools - Fixed Width and Delimiter\". Background\nIntegration files are either fixed-width or delimited files. These should be in text editors. If the data was in Excel tabular format, it would be much easier to analyze.\nYouTube Video\nSolution\nI have created tow tools using Excel to easil..."
url: "https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Excel Tools - Fixed Width and Delimiter](https://ujwal-1664557068125.hashnode.dev/excel-tools-fixed-width-and-delimiter?utm_source=hashnode&utm_medium=feed)

Background Integration files are either fixed-width or delimited files. These should be in text editors. If the data was in Excel tabular format, it would be much easier to analyze. YouTube Video Solution I have created tow tools using Excel to easil...

Jul 1, 2023 · 1 min read · ujwal-1664557068125.hashnode.dev  
Read the article

-   [#powerquery](https://hashnode.com/tag/powerquery)
-   [#excel](https://hashnode.com/tag/excel)
-   [#tools](https://hashnode.com/tag/tools)

## Written by

[Ujwal Reddy](https://hashnode.com/@ujwal)

@ujwal · Pittsburgh, PA, USA

  
[View profile](https://hashnode.com/@ujwal)

Workday Integrations and more

I talk about Workday Integrations. Follow my LinkedIn for more about me.

## Responses 2

Markdown supported · ⌘↵ to post

[Ujwal Reddy](https://hashnode.com/@ujwal)

[Nov 24, 2023](https://hashnode.com/posts/excel-tools-fixed-width-and-delimiter/64a081b339e8d863438faa45/comment/655fecb642de6790b2f79c11)

Hi Puja, I am glad you liked my content.

About comparing two tables, I have created a very beautiful tool in excel using PowerQuery. Please check my latest video (released around 3 months back).

That should solve your problem.

Please let me know if that helps you.

[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 🙏.