Would like a formula which would extract the contents between the word circuit and the second comma in a string:
MPLS - MPLS Services, Circuit 2083676, Verizon, xxxx,,xxxxxxxxxxxxx , xx
MPLS - MPLS Services, Circuit 572222DAT1, xxxx,xxxxx,xxxxx
Hello everyone,
Maybe you are familiar with word Gerber, maybe you are not. It's a file that contains X/Y coordinates, it's most commonly used in different types of Industries, mainly PCB manufacturing and PCB assembly.
I need excel to translate form1 to form2
Form1
Examples:
%FSLAX24Y24*%...
Hi,
I need help figuring out the best way to use the data in sheet 2 to populate all the fields in sheet1. Ultimately, sheet1 will be converted to PDF when all the information is gathered. I'm struggling with making it look good. I'm Currently using If Statements for the yes no questions...
A1:A5 = No. of Veh., Speed, Circuit in Miles, Interval (min or sec), M/P Hour. The variables in B1:B5.
So a typical "what-if" would be something like the Interval must be 1 minute, the Circuit Miles is 120... what would be the other values to meet the 1 min/120 miles set requirements.
Other...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.