Text to columns Delimited

Hello
I have been trying to solve it my own and read about it but 0 results.

The goal I want to achive is following:

I have txt: FDS.DataBase_Name_Location , ISK.Database_name_nope
and I want to them to different columns like "Convert text to Columns Wizard does"
So the result is
FDS Database_name_Location
ISK Database_name_nope

I WANT TO CREATE MACRO BUTTON TO AUTOMATE THIS EXCEL TABLE

Sry if little bit fuzzy text I am in a hurry to lunch

Melx333

welcome to the volunteer self help forums

firstly, you need to clearly explain your issue.

secondly, you should post examples of your spreadsheets with examples of your issue and MOST IMPORTANTLY include examples of what you expect the result to be, most of us who read the forums and try to assist do not have working ESP (extra sensory perception) module3s working so we need to really understand what you are trying to achieve

hope we can collectively assist you on your journey

Jmac

If you have the data in column A and want simply to divide it in two columns:

Please Login or Register  to view this content.

Gerard ty for help
It worked

Do I need to close this post or what I need to do?

Pleasure. You need to go advanced and mark it as "Solved"