[@ammaraiqan]

مشكور انت بطل ❤

[@ExcelASPC]

Thank you. I am happy that it helped. Keep watching for new updates.

[@painless_heart]

Very helpful. I was finding like this tutorial video. But I didn't get. At last I got it from you. Thanks bro.

[@ExcelASPC]

Thank you. I am glad you think so. ,,

[@shivaanmathews6748]

Great video, short and to the point

[@ExcelASPC]

Thank you...

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@laszloturi9633]

you are the best!

[@ExcelASPC]

The best reward I got from you... Thank you for your appreciation.

[@kumarabhinab]

Trust, this is very helpful.

[@ExcelASPC]

Glad it was helpful!

[@zueackerman6059]

THANK YOU VERY MUCHHH

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@sandhyapardeshi7866]

Nice working

[@ExcelASPC]

Thank you. Please keep watching this channel for smarter topics in Excel.

[@louisestokes8592]

thanks

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@pradeepsingh9138]

Thnk u bro

[@ExcelASPC]

Welcome.
Please watch this in this topic.
ua-cam.com/video/pj4E4xlshVk/v-deo.html

[@bankai786]

I have a doubt... can't we just convert the extension of file to CSV and open it in excel....it will be converted easily in rows and columns....please reply

[@ExcelASPC]

Thank you for your query. It will work but not necessarily, excel has much improved. You can test it.
Hint: use the same excel you applied text to column, clear the data and open it.
Happy excel.,,,👍

[@kannasiva4u]

It is not seperating after selecting comma. Showing same after all changes applied in text to column

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@ngocdam5448]

ok

[@tchandrakiran6599]

Hi bro when try to press alt+A+E but it's not working please anyone let us know

[@ExcelASPC]

Thank you for your comment. Please check it in other system. It is basic shortcut and will work.

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@pampideb3414]

👍

[@ExcelASPC]

Happy to help...

[@vickyrodriguez4779]

Hi how can i separate this data through power query using pipe symbol ( | ) please help

[@ExcelASPC]

Yes. It can be. But why not using text to columns option.

[@vickyrodriguez4779]

@@ExcelASPC
Hi Thanks for your response , I have 30 Excel file in Cvs format, daily basis if I try to consolidate the same file in power query which is showing delimiter option after selecting the Pipe line symbol in Power query it is not given expect separation my requirement is same time i want to consolidate the 30 CSV Excel file and separate with using this Pipe "|" symbol please help and do the necessary support through one video

[@ExcelASPC]

I will get back to you.

[@nileshsharma2805]

I want such data samples to practice...
Can u please provide?

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share

[@adarsh_sharma_1896]

Grt

[@ExcelASPC]

Thanks

[@ExcelASPC]

Thanks...

[@adarsh_sharma_1896]

Good

[@ExcelASPC]

Thanks

[@tarunsiddu2024]

can you provide any data sets bro

[@ExcelASPC]

Sure I can. There is one link I will share you soon for practice.

[@ExcelASPC]

Give me some time.

[@ExcelASPC]

Thank you. You can also watch this, it is more flexible.
ua-cam.com/users/shortsreedYgtqVqI?feature=share