Please Help - Data in Text File to be arranged in Excel in a specific

First, two questions: how proficient are you with Word and Excel? Are you comfortable using the REPLACE function in both?

If reasonably proficient and comfortable (understand) with the REPLACE function, it isn't difficult and will take about 15 minutes to accomplish what you seek.

Open the text file in Word.

Turn on the SHOW ALL switch (the paragraph mark icon).

Your post example has MANUAL LINE BREAKS after each line - if the source file has them, replace all of them with PARAGRAPH MARK.




Add a PARAGRAPH MARK (Enter) at the very beginning of the document.






Replace DOUBLE PARAGRAPH MARKS with PARAGRAPH MARK, hash mark (#) - makes it easier to see what you are doing next - and PARAGRAPH MARK like this:

Find what: ^p^p
Replace with: ^p#^p





Now add the tilde (~) in front of each line:

Find what: ^pBSSID:
Replace with: ^p~BSSID:





Repeat for each line of a record (total of 11 times).




Delete all of the hash marks (#):

Find what: ^p#^p
Replace with: ^p




Now your records are:
> Separated by a carriage return (paragraph mark)
> Fields are separated by the tilde (~)
> The first imported column will be EMPTY



Save the txt file and close Word.

Open Excel.
Open file type: All Files (*.*)




Select your text file.

In the import steps:
Step 1: Delimited
Step 2: deselect Tab and select Other, set to ~





Click FINISH.

Insert a header row and label each column.

Select each colum one at a time and delete the corresponding record field leaders. Be sure to include the SPACE that follows the colon as part of the FIND WHAT.





Done.

Save it.

Regards,
GEWB

Great post GEWB! this should be a "sticky".