Formula for Text to Column for the following information to Automate a Spread sheet

[mdouglas1978]

Here is the Information that is in Column G
surveyID=1053463&agentID=CV093V&chatID=745725784084061903&agentGroupID=10005201&VendorManager=Alec Pritzos ap6428&cobrAsst=false&AgentLocation=Hyderabad_OTT&busUnitID=19000956&Vendor=247&BRName=ATT-VASSLC-AEG-DirecTVNow-O-R-G-Care-AuthSub-C2C-Test_170502a_A&customerID=740659023118282038&OpsManager=Bill Lee&siteID=10004119&Team=Kamini

I need to break that information up into Columns for a statistical spreadsheet. Can you help?

 

[Logit]

Re: Need a Formula for Text to Column for the following information to Automate a Spread sheet

.
Paste data to A1
Select DATA menu tab / Text-To-Columns


Select:


Delimited / Next
Other
In the small blank text box enter the & symbol
Next
Finish

 

[ONEMINUTETUTORIAL]

Re: Need a Formula for Text to Column for the following information to Automate a Spread sheet

Hi mdouglas,

Using flash fill you can achieve your results.

please Refer video : https://www.youtube.com/watch?v=1WaRJigzMnk

Still you can able to do. Please share the excel i will help to you.

Regards,