Removing Commas in between quotation mark and numbers Excel Macro

[Lekha mohanty]

In my excel sheet, I have data like

"","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595",""

I want to delete the comma within the number, for example in the above example the value 2878 is mentioned as 2,878, here I want to delete the comma between 2878, and the other commas in the should be there. Only the comma’s within the quotation marks should be deleted.

Result should be like this.
"","2878","-51","58","202.89","3935.80","40.65","50","3910.95","3927.95","50","14250.00","5050","0.40","0.45","7400","0.10","0.40","106.60","2665","-28","8595",""

Extract_261021_112409.csv
	A
1	"CALLS","","PUTS" " ","OI ","Chng in OI ","Volume ","IV ","LTP ","Chng ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Strike Price ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Chng ","LTP ","IV ","Volume ","Chng in OI ","OI "," " "","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595","" "","173","-2","2","239.75","3,950.00","90.00","400","3,798.35","3,888.50","50","14,300.00","1,100","0.40","0.45","1,000","-","0.40","105.16","242","-62","855","" "","-","-","-","-","-","-","850","3,706.50","3,917.65","750","14,350.00","50","0.60","0.65","1,800","-0.05","0.70","108.93","39","17","73","" "","2","-","-","-","-","-","350","3,662.75","3,864.95","1,800","14,400.00","250","0.45","0.55","1,500","-0.05","0.45","103.33","59","-","209","" "","-","-","-","-","-","-","1,000","3,599.25","3,820.05","550","14,450.00","1,500","0.05","1.70","1,500","-","-","-","-","-","-","" "","4,425","-98","136","155.59","3,673.20","22.40","100","3,668.50","3,681.40","150","14,500.00","9,000","0.45","0.50","2,400","0.10","0.45","101.38","984","-200","10,897","" "","-","-","-","-","-","-","400","3,504.70","3,720.95","550","14,550.00","1,500","0.05","2.05","1,500","-","-","-","-","-","-","" "","47","-","-","-","-","-","700","3,451.70","3,665.80","500","14,600.00","450","0.55","0.60","1,500","-0.10","0.60","101.52","72","38","301","" "","-","-","-","-","-","-","600","3,406.30","3,621.30","1,800","14,650.00","1,500","0.15","2.10","1,500","-","-","-","-","-","-","" "","9","-","-","-","-","-","550","3,296.85","3,565.70","500","14,700.00","1,500","0.35","0.50","1,650","-","0.45","94.77","1","-","331","" "","-","-","-","-","-","-","700","3,309.30","3,515.70","750","14,750.00","1,500","0.05","2.10","1,800","-","-","-","-","-","-","" "","138","-1","1","236.32","3,504.25","164.25","1,000","3,282.55","3,457.00","50","14,800.00","150","0.55","0.75","200","-0.10","0.55","93.58","33","-21","18","" "","-","-","-","-","-","-","550","3,185.10","3,505.70","1,650","14,850.00","-","-","2.25","1,800","-","-","-","-","-","-","" "","3","-","-","-","-","-","50","3,206.55","3,323.65","550","14,900.00","100","0.55","0.70","200","0.40","0.85","94.46","113","19","151","" "","4","-","-","-","-","-","50","3,114.90","3,312.65","150","14,950.00","150","0.20","1.65","1,500","-","-","-","-","-","8","" "","7,792","-63","68","147.37","3,174.10","31.75","900","3,159.55","3,179.25","100","15,000.00","20,700","0.45","0.50","11,200","-","0.45","86.32","1,105","-39","14,890","" "","-","-","-","-","-","-","600","2,998.35","3,209.70","800","15,050.00","900","0.05","1.85","1,500","-","-","-","-","-","1","" "","21","-","-","-","-","-","950","2,976.90","3,132.80","1,200","15,100.00","500","0.40","0.75","200","-0.35","0.40","82.68","5","-1","38","" "","-","-","-","-","-","-","700","2,863.90","3,107.90","800","15,150.00","1,500","0.05","2.15","1,500","-","-","-","-","-","-","" "","104","-","-","-","-","-","500","2,870.05","3,052.30","500","15,200.00","1,500","0.35","0.65","250","0.10","0.65","83.51","5","-1","131","" "","-","-","-","-","-","-","600","2,767.75","3,005.40","550","15,250.00","1,500","0.05","1.80","1,500","-","-","-","-","-","-","" "","225","-","-","-","-","-","500","2,809.60","2,903.90","650","15,300.00","50","0.50","0.55","550","-0.10","0.50","79.42","4,551","7","706","" "","-","-","-","-","-","-","550","2,729.90","2,865.75","50","15,350.00","300","0.45","1.85","1,500","-","0.90","81.77","1","-","15","" "","128","-","-","-","-","-","1,050","2,679.00","2,840.25","1,150","15,400.00","200","0.50","0.55","1,750","0.10","0.55","75.25","138","1","545","" "","-","-","-","-","-","-","550","2,622.45","2,794.90","1,650","15,450.00","50","0.55","2.15","50","-","0.70","73.88","8","-5","17","" "","1,822","-","109","129.19","2,683.15","36.35","50","2,679.95","2,684.55","250","15,500.00","1,800","0.65","0.70","1,000","-0.10","0.70","76.04","1,958","-18","15,160","" "","-","-","-","-","-","-","850","2,530.45","2,693.50","900","15,550.00","200","0.55","0.90","50","-","-","-","-","-","29","" "","31","-","-","-","-","-","500","2,483.50","2,640.95","500","15,600.00","350","0.80","0.95","450","0.15","0.80","72.20","112","2","861","" "","-","-","-","-","-","-","550","2,388.65","2,598.65","550","15,650.00","600","0.30","1.75","300","-","-","-","-","-","3","" "","113","-10","17","141.75","2,500.00","60.00","50","2,464.70","2,491.60","50","15,700.00","100","0.70","0.85","50","-0.05","0.80","68.87","107","20","1,335","" "","-","-","-","-","-","-","1,800","2,390.40","2,439.10","1,800","15,750.00","600","0.40","0.75","1,000","-","-","-","-","-","61","" "","339","-","1","155.00","2,440.00","88.75","300","2,367.80","2,387.50","750","15,800.00","450","0.85","0.95","1,000","-0.05","0.90","69.17","149","-9","2,512","" "","1","-","-","-","-","-","1,800","2,299.75","2,339.35","1,800","15,850.00","600","0.40","1.60","200","-","-","-","-","-","4","" "","134","-","1","148.49","2,336.85","109.25","50","2,244.15","2,288.15","1,800","15,900.00","350","0.85","0.95","650","-0.05","0.95","65.93","137","20","673","" "","2","-","-","-","-","-","1,800","2,201.70","2,247.00","1,800","15,950.00","50","0.65","0.85","50","-","-","-","-","-","42","" "","4,987","-4","215","109.94","2,179.50","23.85","400","2,174.55","2,184.40","1,200","16,000.00","7,750","0.75","0.80","5,150","-0.10","0.80","62.32","3,158","277","28,167","" "","7","-","-","-","-","-","50","2,105.30","2,145.70","50","16,050.00","600","0.65","0.80","450","-0.35","0.80","61.65","24","-1","73","" "","222","-4","30","95.92","2,080.00","34.15","200","2,067.40","2,086.25","50","16,100.00","500","0.85","0.90","250","-0.20","0.85","61.22","1,332","90","1,083","" "","15","-","-","-","-","-","50","2,003.60","2,039.45","50","16,150.00","100","1.00","1.20","50","0.05","1.25","60.92","330","6","36","" "","378","-","30","117.78","2,000.50","54.05","100","1,964.40","1,983.30","200","16,200.00","1,200","0.95","1.05","900","-0.15","0.95","58.92","998","93","1,892","" "","2","-","-","-","-","-","50","1,900.75","1,937.35","50","16,250.00","300","0.75","1.15","200","0.05","1.10","57.19","32","1","186","" "","421","-1","60","123.00","1,924.75","72.80","50","1,867.85","1,883.35","400","16,300.00","500","0.95","1.05","800","-","1.00","55.75","1,196","72","6,340","" "","7","-","-","-","-","-","50","1,801.45","1,835.30","50","16,350.00","400","0.75","1.45","100","-","1.05","54.04","3","-2","121","" "","379","-3","4","107.85","1,800.00","52.25","100","1,756.40","1,786.80","50","16,400.00","1,350","1.05","1.10","400","0.15","1.15","52.61","1,066","73","2,135","" "","6","-","-","-","-","-","1,800","1,710.40","1,743.00","50","16,450.00","600","0.85","1.35","50","0.25","1.05","51.17","35","-","166","" "","8,410","-12","131","79.64","1,675.00","28.90","50","1,674.65","1,682.40","50","16,500.00","9,650","1.15","1.20","30,850","-0.05","1.15","50.95","16,562","-366","42,448","" "","19","-","5","76.01","1,603.10","-6.90","50","1,603.30","1,634.50","1,800","16,550.00","1,150","1.00","1.45","100","-0.25","0.85","47.22","4","2","298","" "","607","-","2","124.29","1,568.25","10.95","50","1,568.35","1,584.75","50","16,600.00","1,500","1.20","1.25","650","0.10","1.25","48.24","3,711","386","5,266","" "","454","-","-","-","-","-","50","1,505.05","1,535.45","50","16,650.00","200","1.15","1.55","50","0.55","1.65","47.91","77","-14","1,158","" "","1,358","-","32","72.45","1,457.00","0.10","50","1,472.75","1,485.40","450","16,700.00","4,550","1.30","1.35","5,000","0.05","1.30","45.51","4,816","420","8,757","" "","78","-","-","-","-","-","1,800","1,413.90","1,442.25","50","16,750.00","100","1.10","1.30","50","0.35","1.40","44.05","116","-8","316","" "","697","-","-","-","-","-","50","1,366.40","1,384.65","50","16,800.00","5,150","1.30","1.35","1,450","0.10","1.35","42.58","9,475","378","20,209","" "","53","-","5","96.21","1,379.65","138.65","50","1,291.80","1,347.15","50","16,850.00","800","1.45","1.55","1,200","0.60","1.95","41.78","720","312","697","" "","1,116","-1","14","93.02","1,328.00","70.00","50","1,271.70","1,283.95","50","16,900.00","8,600","1.40","1.45","3,750","-","1.45","39.97","11,865","-77","16,451","" "","44","1","2","82.17",
Extract_261021_112409

Please help me with the excel macro code.

 

[KOKOSEK]

Try something this way:

Book2
	A
1	"CALLS","","PUTS" " ","OI ","Chng in OI ","Volume ","IV ","LTP ","Chng ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Strike Price ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Chng ","LTP ","IV ","Volume ","Chng in OI ","OI "," " "","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595","" "","173","-2","2","239.75","3,950.00","90.00","400","3,798.35","3,888.50","50","14,300.00","1,100","0.40","0.45","1,000","-","0.40","105.16","242","-62","855","" "","-","-","-","-","-","-","850","3,706.50","3,917.65","750","14,350.00","50","0.60","0.65","1,800","-0.05","0.70","108.93","39","17","73","" "","2","-","-","-","-","-","350","3,662.75","3,864.95","1,800","14,400.00","250","0.45","0.55","1,500","-0.05","0.45","103.33","59","-","209","" "","-","-","-","-","-","-","1,000","3,599.25","3,820.05","550","14,450.00","1,500","0.05","1.70","1,500","-","-","-","-","-","-","" "","4,425","-98","136","155.59","3,673.20","22.40","100","3,668.50","3,681.40","150","14,500.00","9,000","0.45","0.50","2,400","0.10","0.45","101.38","984","-200","10,897","" "","-","-","-","-","-","-","400","3,504.70","3,720.95","550","14,550.00","1,500","0.05","2.05","1,500","-","-","-","-","-","-","" "","47","-","-","-","-","-","700","3,451.70","3,665.80","500","14,600.00","450","0.55","0.60","1,500","-0.10","0.60","101.52","72","38","301","" "","-","-","-","-","-","-","600","3,406.30","3,621.30","1,800","14,650.00","1,500","0.15","2.10","1,500","-","-","-","-","-","-","" "","9","-","-","-","-","-","550","3,296.85","3,565.70","500","14,700.00","1,500","0.35","0.50","1,650","-","0.45","94.77","1","-","331","" "","-","-","-","-","-","-","700","3,309.30","3,515.70","750","14,750.00","1,500","0.05","2.10","1,800","-","-","-","-","-","-","" "","138","-1","1","236.32","3,504.25","164.25","1,000","3,282.55","3,457.00","50","14,800.00","150","0.55","0.75","200","-0.10","0.55","93.58","33","-21","18","" "","-","-","-","-","-","-","550","3,185.10","3,505.70","1,650","14,850.00","-","-","2.25","1,800","-","-","-","-","-","-","" "","3","-","-","-","-","-","50","3,206.55","3,323.65","550","14,900.00","100","0.55","0.70","200","0.40","0.85","94.46","113","19","151","" "","4","-","-","-","-","-","50","3,114.90","3,312.65","150","14,950.00","150","0.20","1.65","1,500","-","-","-","-","-","8","" "","7,792","-63","68","147.37","3,174.10","31.75","900","3,159.55","3,179.25","100","15,000.00","20,700","0.45","0.50","11,200","-","0.45","86.32","1,105","-39","14,890","" "","-","-","-","-","-","-","600","2,998.35","3,209.70","800","15,050.00","900","0.05","1.85","1,500","-","-","-","-","-","1","" "","21","-","-","-","-","-","950","2,976.90","3,132.80","1,200","15,100.00","500","0.40","0.75","200","-0.35","0.40","82.68","5","-1","38","" "","-","-","-","-","-","-","700","2,863.90","3,107.90","800","15,150.00","1,500","0.05","2.15","1,500","-","-","-","-","-","-","" "","104","-","-","-","-","-","500","2,870.05","3,052.30","500","15,200.00","1,500","0.35","0.65","250","0.10","0.65","83.51","5","-1","131","" "","-","-","-","-","-","-","600","2,767.75","3,005.40","550","15,250.00","1,500","0.05","1.80","1,500","-","-","-","-","-","-","" "","225","-","-","-","-","-","500","2,809.60","2,903.90","650","15,300.00","50","0.50","0.55","550","-0.10","0.50","79.42","4,551","7","706","" "","-","-","-","-","-","-","550","2,729.90","2,865.75","50","15,350.00","300","0.45","1.85","1,500","-","0.90","81.77","1","-","15","" "","128","-","-","-","-","-","1,050","2,679.00","2,840.25","1,150","15,400.00","200","0.50","0.55","1,750","0.10","0.55","75.25","138","1","545","" "","-","-","-","-","-","-","550","2,622.45","2,794.90","1,650","15,450.00","50","0.55","2.15","50","-","0.70","73.88","8","-5","17","" "","1,822","-","109","129.19","2,683.15","36.35","50","2,679.95","2,684.55","250","15,500.00","1,800","0.65","0.70","1,000","-0.10","0.70","76.04","1,958","-18","15,160","" "","-","-","-","-","-","-","850","2,530.45","2,693.50","900","15,550.00","200","0.55","0.90","50","-","-","-","-","-","29","" "","31","-","-","-","-","-","500","2,483.50","2,640.95","500","15,600.00","350","0.80","0.95","450","0.15","0.80","72.20","112","2","861","" "","-","-","-","-","-","-","550","2,388.65","2,598.65","550","15,650.00","600","0.30","1.75","300","-","-","-","-","-","3","" "","113","-10","17","141.75","2,500.00","60.00","50","2,464.70","2,491.60","50","15,700.00","100","0.70","0.85","50","-0.05","0.80","68.87","107","20","1,335","" "","-","-","-","-","-","-","1,800","2,390.40","2,439.10","1,800","15,750.00","600","0.40","0.75","1,000","-","-","-","-","-","61","" "","339","-","1","155.00","2,440.00","88.75","300","2,367.80","2,387.50","750","15,800.00","450","0.85","0.95","1,000","-0.05","0.90","69.17","149","-9","2,512","" "","1","-","-","-","-","-","1,800","2,299.75","2,339.35","1,800","15,850.00","600","0.40","1.60","200","-","-","-","-","-","4","" "","134","-","1","148.49","2,336.85","109.25","50","2,244.15","2,288.15","1,800","15,900.00","350","0.85","0.95","650","-0.05","0.95","65.93","137","20","673","" "","2","-","-","-","-","-","1,800","2,201.70","2,247.00","1,800","15,950.00","50","0.65","0.85","50","-","-","-","-","-","42","" "","4,987","-4","215","109.94","2,179.50","23.85","400","2,174.55","2,184.40","1,200","16,000.00","7,750","0.75","0.80","5,150","-0.10","0.80","62.32","3,158","277","28,167","" "","7","-","-","-","-","-","50","2,105.30","2,145.70","50","16,050.00","600","0.65","0.80","450","-0.35","0.80","61.65","24","-1","73","" "","222","-4","30","95.92","2,080.00","34.15","200","2,067.40","2,086.25","50","16,100.00","500","0.85","0.90","250","-0.20","0.85","61.22","1,332","90","1,083","" "","15","-","-","-","-","-","50","2,003.60","2,039.45","50","16,150.00","100","1.00","1.20","50","0.05","1.25","60.92","330","6","36","" "","378","-","30","117.78","2,000.50","54.05","100","1,964.40","1,983.30","200","16,200.00","1,200","0.95","1.05","900","-0.15","0.95","58.92","998","93","1,892","" "","2","-","-","-","-","-","50","1,900.75","1,937.35","50","16,250.00","300","0.75","1.15","200","0.05","1.10","57.19","32","1","186","" "","421","-1","60","123.00","1,924.75","72.80","50","1,867.85","1,883.35","400","16,300.00","500","0.95","1.05","800","-","1.00","55.75","1,196","72","6,340","" "","7","-","-","-","-","-","50","1,801.45","1,835.30","50","16,350.00","400","0.75","1.45","100","-","1.05","54.04","3","-2","121","" "","379","-3","4","107.85","1,800.00","52.25","100","1,756.40","1,786.80","50","16,400.00","1,350","1.05","1.10","400","0.15","1.15","52.61","1,066","73","2,135","" "","6","-","-","-","-","-","1,800","1,710.40","1,743.00","50","16,450.00","600","0.85","1.35","50","0.25","1.05","51.17","35","-","166","" "","8,410","-12","131","79.64","1,675.00","28.90","50","1,674.65","1,682.40","50","16,500.00","9,650","1.15","1.20","30,850","-0.05","1.15","50.95","16,562","-366","42,448","" "","19","-","5","76.01","1,603.10","-6.90","50","1,603.30","1,634.50","1,800","16,550.00","1,150","1.00","1.45","100","-0.25","0.85","47.22","4","2","298","" "","607","-","2","124.29","1,568.25","10.95","50","1,568.35","1,584.75","50","16,600.00","1,500","1.20","1.25","650","0.10","1.25","48.24","3,711","386","5,266","" "","454","-","-","-","-","-","50","1,505.05","1,535.45","50","16,650.00","200","1.15","1.55","50","0.55","1.65","47.91","77","-14","1,158","" "","1,358","-","32","72.45","1,457.00","0.10","50","1,472.75","1,485.40","450","16,700.00","4,550","1.30","1.35","5,000","0.05","1.30","45.51","4,816","420","8,757","" "","78","-","-","-","-","-","1,800","1,413.90","1,442.25","50","16,750.00","100","1.10","1.30","50","0.35","1.40","44.05","116","-8","316","" "","697","-","-","-","-","-","50","1,366.40","1,384.65","50","16,800.00","5,150","1.30","1.35","1,450","0.10","1.35","42.58","9,475","378","20,209","" "","53","-","5","96.21","1,379.65","138.65","50","1,291.80","1,347.15","50","16,850.00","800","1.45","1.55","1,200","0.60","1.95","41.78","720","312","697","" "","1,116","-1","14","93.02","1,328.00","70.00","50","1,271.70","1,283.95","50","16,900.00","8,600","1.40","1.45","3,750","-","1.45","39.97","11,865","-77","16,451","" "","44","1","2","82.17",
2	"CALLS","","PUTS" " ","OI ","Chng in OI ","Volume ","IV ","LTP ","Chng ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Strike Price ","Bid Qty ","Bid Price ","Ask Price ","Ask Qty ","Chng ","LTP ","IV ","Volume ","Chng in OI ","OI "," " "","2878","-51","58","202.89","3935.80","40.65","50","3910.95","3927.95","50","14250.00","5050","0.40","0.45","7400","0.10","0.40","106.60","2665","-28","8595","" "","173","-2","2","239.75","3950.00","90.00","400","3798.35","3888.50","50","14300.00","1100","0.40","0.45","1000","-","0.40","105.16","242","-62","855","" "","-","-","-","-","-","-","850","3706.50","3917.65","750","14350.00","50","0.60","0.65","1800","-0.05","0.70","108.93","39","17","73","" "","2","-","-","-","-","-","350","3662.75","3864.95","1800","14400.00","250","0.45","0.55","1500","-0.05","0.45","103.33","59","-","209","" "","-","-","-","-","-","-","1000","3599.25","3820.05","550","14450.00","1500","0.05","1.70","1500","-","-","-","-","-","-","" "","4425","-98","136","155.59","3673.20","22.40","100","3668.50","3681.40","150","14500.00","9000","0.45","0.50","2400","0.10","0.45","101.38","984","-200","10897","" "","-","-","-","-","-","-","400","3504.70","3720.95","550","14550.00","1500","0.05","2.05","1500","-","-","-","-","-","-","" "","47","-","-","-","-","-","700","3451.70","3665.80","500","14600.00","450","0.55","0.60","1500","-0.10","0.60","101.52","72","38","301","" "","-","-","-","-","-","-","600","3406.30","3621.30","1800","14650.00","1500","0.15","2.10","1500","-","-","-","-","-","-","" "","9","-","-","-","-","-","550","3296.85","3565.70","500","14700.00","1500","0.35","0.50","1650","-","0.45","94.77","1","-","331","" "","-","-","-","-","-","-","700","3309.30","3515.70","750","14750.00","1500","0.05","2.10","1800","-","-","-","-","-","-","" "","138","-1","1","236.32","3504.25","164.25","1000","3282.55","3457.00","50","14800.00","150","0.55","0.75","200","-0.10","0.55","93.58","33","-21","18","" "","-","-","-","-","-","-","550","3185.10","3505.70","1650","14850.00","-","-","2.25","1800","-","-","-","-","-","-","" "","3","-","-","-","-","-","50","3206.55","3323.65","550","14900.00","100","0.55","0.70","200","0.40","0.85","94.46","113","19","151","" "","4","-","-","-","-","-","50","3114.90","3312.65","150","14950.00","150","0.20","1.65","1500","-","-","-","-","-","8","" "","7792","-63","68","147.37","3174.10","31.75","900","3159.55","3179.25","100","15000.00","20700","0.45","0.50","11200","-","0.45","86.32","1105","-39","14890","" "","-","-","-","-","-","-","600","2998.35","3209.70","800","15050.00","900","0.05","1.85","1500","-","-","-","-","-","1","" "","21","-","-","-","-","-","950","2976.90","3132.80","1200","15100.00","500","0.40","0.75","200","-0.35","0.40","82.68","5","-1","38","" "","-","-","-","-","-","-","700","2863.90","3107.90","800","15150.00","1500","0.05","2.15","1500","-","-","-","-","-","-","" "","104","-","-","-","-","-","500","2870.05","3052.30","500","15200.00","1500","0.35","0.65","250","0.10","0.65","83.51","5","-1","131","" "","-","-","-","-","-","-","600","2767.75","3005.40","550","15250.00","1500","0.05","1.80","1500","-","-","-","-","-","-","" "","225","-","-","-","-","-","500","2809.60","2903.90","650","15300.00","50","0.50","0.55","550","-0.10","0.50","79.42","4551","7","706","" "","-","-","-","-","-","-","550","2729.90","2865.75","50","15350.00","300","0.45","1.85","1500","-","0.90","81.77","1","-","15","" "","128","-","-","-","-","-","1050","2679.00","2840.25","1150","15400.00","200","0.50","0.55","1750","0.10","0.55","75.25","138","1","545","" "","-","-","-","-","-","-","550","2622.45","2794.90","1650","15450.00","50","0.55","2.15","50","-","0.70","73.88","8","-5","17","" "","1822","-","109","129.19","2683.15","36.35","50","2679.95","2684.55","250","15500.00","1800","0.65","0.70","1000","-0.10","0.70","76.04","1958","-18","15160","" "","-","-","-","-","-","-","850","2530.45","2693.50","900","15550.00","200","0.55","0.90","50","-","-","-","-","-","29","" "","31","-","-","-","-","-","500","2483.50","2640.95","500","15600.00","350","0.80","0.95","450","0.15","0.80","72.20","112","2","861","" "","-","-","-","-","-","-","550","2388.65","2598.65","550","15650.00","600","0.30","1.75","300","-","-","-","-","-","3","" "","113","-10","17","141.75","2500.00","60.00","50","2464.70","2491.60","50","15700.00","100","0.70","0.85","50","-0.05","0.80","68.87","107","20","1335","" "","-","-","-","-","-","-","1800","2390.40","2439.10","1800","15750.00","600","0.40","0.75","1000","-","-","-","-","-","61","" "","339","-","1","155.00","2440.00","88.75","300","2367.80","2387.50","750","15800.00","450","0.85","0.95","1000","-0.05","0.90","69.17","149","-9","2512","" "","1","-","-","-","-","-","1800","2299.75","2339.35","1800","15850.00","600","0.40","1.60","200","-","-","-","-","-","4","" "","134","-","1","148.49","2336.85","109.25","50","2244.15","2288.15","1800","15900.00","350","0.85","0.95","650","-0.05","0.95","65.93","137","20","673","" "","2","-","-","-","-","-","1800","2201.70","2247.00","1800","15950.00","50","0.65","0.85","50","-","-","-","-","-","42","" "","4987","-4","215","109.94","2179.50","23.85","400","2174.55","2184.40","1200","16000.00","7750","0.75","0.80","5150","-0.10","0.80","62.32","3158","277","28167","" "","7","-","-","-","-","-","50","2105.30","2145.70","50","16050.00","600","0.65","0.80","450","-0.35","0.80","61.65","24","-1","73","" "","222","-4","30","95.92","2080.00","34.15","200","2067.40","2086.25","50","16100.00","500","0.85","0.90","250","-0.20","0.85","61.22","1332","90","1083","" "","15","-","-","-","-","-","50","2003.60","2039.45","50","16150.00","100","1.00","1.20","50","0.05","1.25","60.92","330","6","36","" "","378","-","30","117.78","2000.50","54.05","100","1964.40","1983.30","200","16200.00","1200","0.95","1.05","900","-0.15","0.95","58.92","998","93","1892","" "","2","-","-","-","-","-","50","1900.75","1937.35","50","16250.00","300","0.75","1.15","200","0.05","1.10","57.19","32","1","186","" "","421","-1","60","123.00","1924.75","72.80","50","1867.85","1883.35","400","16300.00","500","0.95","1.05","800","-","1.00","55.75","1196","72","6340","" "","7","-","-","-","-","-","50","1801.45","1835.30","50","16350.00","400","0.75","1.45","100","-","1.05","54.04","3","-2","121","" "","379","-3","4","107.85","1800.00","52.25","100","1756.40","1786.80","50","16400.00","1350","1.05","1.10","400","0.15","1.15","52.61","1066","73","2135","" "","6","-","-","-","-","-","1800","1710.40","1743.00","50","16450.00","600","0.85","1.35","50","0.25","1.05","51.17","35","-","166","" "","8410","-12","131","79.64","1675.00","28.90","50","1674.65","1682.40","50","16500.00","9650","1.15","1.20","30850","-0.05","1.15","50.95","16562","-366","42448","" "","19","-","5","76.01","1603.10","-6.90","50","1603.30","1634.50","1800","16550.00","1150","1.00","1.45","100","-0.25","0.85","47.22","4","2","298","" "","607","-","2","124.29","1568.25","10.95","50","1568.35","1584.75","50","16600.00","1500","1.20","1.25","650","0.10","1.25","48.24","3711","386","5266","" "","454","-","-","-","-","-","50","1505.05","1535.45","50","16650.00","200","1.15","1.55","50","0.55","1.65","47.91","77","-14","1158","" "","1358","-","32","72.45","1457.00","0.10","50","1472.75","1485.40","450","16700.00","4550","1.30","1.35","5000","0.05","1.30","45.51","4816","420","8757","" "","78","-","-","-","-","-","1800","1413.90","1442.25","50","16750.00","100","1.10","1.30","50","0.35","1.40","44.05","116","-8","316","" "","697","-","-","-","-","-","50","1366.40","1384.65","50","16800.00","5150","1.30","1.35","1450","0.10","1.35","42.58","9475","378","20209","" "","53","-","5","96.21","1379.65","138.65","50","1291.80","1347.15","50","16850.00","800","1.45","1.55","1200","0.60","1.95","41.78","720","312","697","" "","1116","-1","14","93.02","1328.00","70.00","50","1271.70","1283.95","50","16900.00","8600","1.40","1.45","3750","-","1.45","39.97","11865","-77","16451","" "","44","1","2","82.17"
Sheet1

Cell Formulas
Range	Formula
A2	A2	=RemoveCommas(A1)

And this UDF is:

Function RemoveCommas(inputStr As String) As String
a = Replace(inputStr, Chr(34) & "," & Chr(34), "^")
a = Split(a, "^")
For i = LBound(a) To UBound(a)
   a(i) = Replace(a(i), ",", "")
Next i
RemoveCommas = Join(a, Chr(34) & "," & Chr(34))
End Function

 

[Lekha mohanty]

Thank you so much

 

[Lekha mohanty]

After eliminating the comma, I want to replace all the quotation marks into blank, or simply delete all the quotation ( " ) marks from the sheet. can you please help me with that ?

 

[KOKOSEK]

Try this:

Function RemoveCommasAndQuotes(inputStr As String) As String
a = Replace(inputStr, Chr(34) & "," & Chr(34), "^")
a = Replace(a, """", "")
a = Split(a, "^")
For i = LBound(a) To UBound(a)
   a(i) = Replace(a(i), ",", "")
Next i
RemoveCommasAndQuotes = Join(a, ",")
End Function

 

[Peter_SSs]

Or without any looping

Function CleanUp(s As String) As String
  With CreateObject("VBScript.RegExp")
    .Global = True
    .Pattern = "("")|(,(?=\d))"
    CleanUp = .Replace(s, "")
  End With
End Function

Lekha mohanty.xlsm
	A	B
1	"","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595",""	,2878,-51,58,202.89,3935.80,40.65,50,3910.95,3927.95,50,14250.00,5050,0.40,0.45,7400,0.10,0.40,106.60,2665,-28,8595,
Sheet1

Cell Formulas
Range	Formula
B1	B1	=CleanUp(A1)

 

[Peter_SSs]

.. or I guess more simply

Function CleanIt(s As String) As String
  CleanIt = Replace(Replace(Replace(Replace(s, """,""", "#"), ",", ""), "#", ","), """", "")
End Function

Lekha mohanty.xlsm
	A	B
1	"","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595",""	,2878,-51,58,202.89,3935.80,40.65,50,3910.95,3927.95,50,14250.00,5050,0.40,0.45,7400,0.10,0.40,106.60,2665,-28,8595,
Sheet1

Cell Formulas
Range	Formula
B1	B1	=CleanIt(A1)

 

[Peter_SSs]

.. or do you really need vba when a reasonably short standard worksheet formula will do the same job?

Lekha mohanty.xlsm
	A	B
1	"","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595",""	,2878,-51,58,202.89,3935.80,40.65,50,3910.95,3927.95,50,14250.00,5050,0.40,0.45,7400,0.10,0.40,106.60,2665,-28,8595,
Sheet1

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,""",""","#"),",",""),"#",","),"""","")

 

[Lekha mohanty]

Thank you Kokosek and Peter for help till now, I was doing the task in a csv file hence removing comma is working, but when I removed the quotation using your formula that is also working but the result is not coming out as per my expectation. There are total 21 columns and data in columns. After removing the comma and opening the file in MS word and after removing the quotations there and again saving the file as CSV then again if I will open the file them I am getting the desired result in 21 columns.

Now I will do this in excel after removing the comma, I want a macro code to separate the data into 21 columns.

"","2878","-51","58","202.89","3935.80","40.65","50","3910.95","3927.95","50","14250.00","5050","0.40","0.45","7400","0.10","0.40","106.60","2665","-28","8595",""

After removing the comma the data looks like this. there is additional "", at the starting and ,"" after each row ending and in between quotation and comma the cell value is there. I want in to extract into different cells in Sheet 2. Please help me with the code.

I want the output to look like this.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	CALLS		PUTS
2		OI	Chng in OI	Volume	IV	LTP	Chng	Bid Qty	Bid Price	Ask Price	Ask Qty	Strike Price	Bid Qty	Bid Price	Ask Price	Ask Qty	Chng	LTP	IV	Volume	Chng in OI	OI
3		2878	-51	58	202.89	3935.8	40.65	50	3910.95	3927.95	50	14250	5050	0.4	0.45	7400	0.1	0.4	106.6	2665	-28	8595
4		173	-2	2	239.75	3950	90	400	3798.35	3888.5	50	14300	1100	0.4	0.45	1000	-	0.4	105.16	242	-62	855
5		-	-	-	-	-	-	850	3706.5	3917.65	750	14350	50	0.6	0.65	1800	-0.05	0.7	108.93	39	17	73
6		2	-	-	-	-	-	350	3662.75	3864.95	1800	14400	250	0.45	0.55	1500	-0.05	0.45	103.33	59	-	209
7		-	-	-	-	-	-	1000	3599.25	3820.05	550	14450	1500	0.05	1.7	1500	-	-	-	-	-	-
8		4425	-98	136	155.59	3673.2	22.4	100	3668.5	3681.4	150	14500	9000	0.45	0.5	2400	0.1	0.45	101.38	984	-200	10897
9		-	-	-	-	-	-	400	3504.7	3720.95	550	14550	1500	0.05	2.05	1500	-	-	-	-	-	-
10		47	-	-	-	-	-	700	3451.7	3665.8	500	14600	450	0.55	0.6	1500	-0.1	0.6	101.52	72	38	301
11		-	-	-	-	-	-	600	3406.3	3621.3	1800	14650	1500	0.15	2.1	1500	-	-	-	-	-	-
12		9	-	-	-	-	-	550	3296.85	3565.7	500	14700	1500	0.35	0.5	1650	-	0.45	94.77	1	-	331
13		-	-	-	-	-	-	700	3309.3	3515.7	750	14750	1500	0.05	2.1	1800	-	-	-	-	-	-
14		138	-1	1	236.32	3504.25	164.25	1000	3282.55	3457	50	14800	150	0.55	0.75	200	-0.1	0.55	93.58	33	-21	18
15		-	-	-	-	-	-	550	3185.1	3505.7	1650	14850	-	-	2.25	1800	-	-	-	-	-	-
16		3	-	-	-	-	-	50	3206.55	3323.65	550	14900	100	0.55	0.7	200	0.4	0.85	94.46	113	19	151
17		4	-	-	-	-	-	50	3114.9	3312.65	150	14950	150	0.2	1.65	1500	-	-	-	-	-	8
18		7792	-63	68	147.37	3174.1	31.75	900	3159.55	3179.25	100	15000	20700	0.45	0.5	11200	-	0.45	86.32	1105	-39	14890
19		-	-	-	-	-	-	600	2998.35	3209.7	800	15050	900	0.05	1.85	1500	-	-	-	-	-	1
20		21	-	-	-	-	-	950	2976.9	3132.8	1200	15100	500	0.4	0.75	200	-0.35	0.4	82.68	5	-1	38
21		-	-	-	-	-	-	700	2863.9	3107.9	800	15150	1500	0.05	2.15	1500	-	-	-	-	-	-
22		104	-	-	-	-	-	500	2870.05	3052.3	500	15200	1500	0.35	0.65	250	0.1	0.65	83.51	5	-1	131
23		-	-	-	-	-	-	600	2767.75	3005.4	550	15250	1500	0.05	1.8	1500	-	-	-	-	-	-
24		225	-	-	-	-	-	500	2809.6	2903.9	650	15300	50	0.5	0.55	550	-0.1	0.5	79.42	4551	7	706
25		-	-	-	-	-	-	550	2729.9	2865.75	50	15350	300	0.45	1.85	1500	-	0.9	81.77	1	-	15
26		128	-	-	-	-	-	1050	2679	2840.25	1150	15400	200	0.5	0.55	1750	0.1	0.55	75.25	138	1	545
27		-	-	-	-	-	-	550	2622.45	2794.9	1650	15450	50	0.55	2.15	50	-	0.7	73.88	8	-5	17
28		1822	-	109	129.19	2683.15	36.35	50	2679.95	2684.55	250	15500	1800	0.65	0.7	1000	-0.1	0.7	76.04	1958	-18	15160
29		-	-	-	-	-	-	850	2530.45	2693.5	900	15550	200	0.55	0.9	50	-	-	-	-	-	29
30		31	-	-	-	-	-	500	2483.5	2640.95	500	15600	350	0.8	0.95	450	0.15	0.8	72.2	112	2	861
31		-	-	-	-	-	-	550	2388.65	2598.65	550	15650	600	0.3	1.75	300	-	-	-	-	-	3
32		113	-10	17	141.75	2500	60	50	2464.7	2491.6	50	15700	100	0.7	0.85	50	-0.05	0.8	68.87	107	20	1335
33		-	-	-	-	-	-	1800	2390.4	2439.1	1800	15750	600	0.4	0.75	1000	-	-	-	-	-	61
34		339	-	1	155	2440	88.75	300	2367.8	2387.5	750	15800	450	0.85	0.95	1000	-0.05	0.9	69.17	149	-9	2512
35		1	-	-	-	-	-	1800	2299.75	2339.35	1800	15850	600	0.4	1.6	200	-	-	-	-	-	4
36		134	-	1	148.49	2336.85	109.25	50	2244.15	2288.15	1800	15900	350	0.85	0.95	650	-0.05	0.95	65.93	137	20	673
37		2	-	-	-	-	-	1800	2201.7	2247	1800	15950	50	0.65	0.85	50	-	-	-	-	-	42
38		4987	-4	215	109.94	2179.5	23.85	400	2174.55	2184.4	1200	16000	7750	0.75	0.8	5150	-0.1	0.8	62.32	3158	277	28167
39		7	-	-	-	-	-	50	2105.3	2145.7	50	16050	600	0.65	0.8	450	-0.35	0.8	61.65	24	-1	73
40		222	-4	30	95.92	2080	34.15	200	2067.4	2086.25	50	16100	500	0.85	0.9	250	-0.2	0.85	61.22	1332	90	1083
41		15	-	-	-	-	-	50	2003.6	2039.45	50	16150	100	1	1.2	50	0.05	1.25	60.92	330	6	36
42		378	-	30	117.78	2000.5	54.05	100	1964.4	1983.3	200	16200	1200	0.95	1.05	900	-0.15	0.95	58.92	998	93	1892
43		2	-	-	-	-	-	50	1900.75	1937.35	50	16250	300	0.75	1.15	200	0.05	1.1	57.19	32	1	186
44		421	-1	60	123	1924.75	72.8	50	1867.85	1883.35	400	16300	500	0.95	1.05	800	-	1	55.75	1196	72	6340
45		7	-	-	-	-	-	50	1801.45	1835.3	50	16350	400	0.75	1.45	100	-	1.05	54.04	3	-2	121
46		379	-3	4	107.85	1800	52.25	100	1756.4	1786.8	50	16400	1350	1.05	1.1	400	0.15	1.15	52.61	1066	73	2135
47		6	-	-	-	-	-	1800	1710.4	1743	50	16450	600	0.85	1.35	50	0.25	1.05	51.17	35	-	166
48		8410	-12	131	79.64	1675	28.9	50	1674.65	1682.4	50	16500	9650	1.15	1.2	30850	-0.05	1.15	50.95	16562	-366	42448
49		19	-	5	76.01	1603.1	-6.9	50	1603.3	1634.5	1800	16550	1150	1	1.45	100	-0.25	0.85	47.22	4	2	298
50		607	-	2	124.29	1568.25	10.95	50	1568.35	1584.75	50	16600	1500	1.2	1.25	650	0.1	1.25	48.24	3711	386	5266
51		454	-	-	-	-	-	50	1505.05	1535.45	50	16650	200	1.15	1.55	50	0.55	1.65	47.91	77	-14	1158
52		1358	-	32	72.45	1457	0.1	50	1472.75	1485.4	450	16700	4550	1.3	1.35	5000	0.05	1.3	45.51	4816	420	8757
53		78	-	-	-	-	-	1800	1413.9	1442.25	50	16750	100	1.1	1.3	50	0.35	1.4	44.05	116	-8	316
54		697	-	-	-	-	-	50	1366.4	1384.65	50	16800	5150	1.3	1.35	1450	0.1	1.35	42.58	9475	378	20209
55		53	-	5	96.21	1379.65	138.65	50	1291.8	1347.15	50	16850	800	1.45	1.55	1200	0.6	1.95	41.78	720	312	697
56		1116	-1	14	93.02	1328	70	50	1271.7	1283.95	50	16900	8600	1.4	1.45	3750	-	1.45	39.97	11865	-77	16451
57		44	1	2	82.17	1222.45	61.2	50	1192	1254.95	50	16950	1000	1.35	1.55	200	0.2	1.5	38.8	636	-38	1842
58		10402	-103	187	66.32	1181.8	35.85	100	1176.15	1181.65	1550	17000	13850	1.75	1.8	32850	0.1	1.75	38.14	68405	-5931	70116
59		50	-	-	-	-	-	50	1115.2	1132.15	450	17050	200	1.85	1.95	1400	0.25	1.95	37.23	561	-121	1291
60		1152	-	9	81.14	1124.1	66	100	1074.4	1082.1	50	17100	6700	2	2.05	3300	0.05	2.05	36.13	20202	-1596	18362
61		63	-	-	-	-	-	1000	1021.75	1031.15	1000	17150	1150	2.1	2.2	50	0.3	2.3	34.97	1361	-66	1877
62		2324	-31	126	52.71	977.6	34.45	150	975.15	981.5	800	17200	2700	2.3	2.35	2400	-	2.3	33.75	33270	4256	33586
63		92	-4	6	51.02	911.1	20.55	1250	916.6	935.15	50	17250	1200	2.55	2.65	1050	-0.1	2.55	32.82	5358	-721	5053
64		2434	-9	27	63.06	883.4	32.9	300	873.95	883	50	17300	1400	2.9	2.95	650	-0.1	2.9	31.7	60599	-1105	34556
65		96	-	3	69.55	842.65	77.1	1000	817.95	831.85	1000	17350	1150	3.3	3.4	50	-0.2	3.35	31.54	7983	-324	7901
66		2404	-22	67	48.42	776	22.75	100	775.9	782.65	300	17400	3200	3.95	4	2650	-0.4	3.95	29.87	118485	23631	62892
67		196	1	5	61.77	773.3	70.3	50	717.25	736.1	50	17450	50	4.35	4.4	250	-0.75	4.35	28.44	15414	425	7287
68		12585	-375	1850	41.22	680	27.65	50	679.8	681.5	100	17500	1000	5.15	5.2	1050	-1.35	5.15	27.55	124127	1292	80096
69		243	-	5	54.73	627.25	9.65	1000	621.45	634.9	200	17550	100	5.85	5.9	50	-1.65	5.85	26.29	28031	2593	12647
70		5460	-180	553	35.57	576.4	17.6	50	581.7	583.35	50	17600	350	7.05	7.1	350	-2.45	7	25.45	108763	-1117	45630
71		741	-	44	59.73	532.85	25.65	100	531.95	534.8	50	17650	50	8.6	8.65	150	-3	8.65	24.6	33777	342	9581
72		9725	-1168	2854	32.38	482.35	17.45	50	485.25	486.85	150	17700	700	10.65	10.75	1100	-4.5	10.65	23.8	124245	8028	42212
73		624	-16	228	35.81	445.7	26.65	50	438.5	440.05	50	17750	100	13.6	13.65	400	-5.65	13.65	23.12	59093	11134	19590
74		16042	-10	4183	29.8	394	22.1	100	391.9	393.25	200	17800	950	17.85	17.95	1900	-6.75	17.9	22.48	182141	3504	66122
75		1027	43	377	29.29	341.35	12.85	50	348	349.3	50	17850	200	23.1	23.2	1550	-7.85	23.35	22	78397	3424	12249
76		11581	-322	9805	27.79	305.85	19.1	50	305.45	306.65	200	17900	150	30	30.1	600	-9.5	30.05	21.43	237254	-1941	48440
77		1011	-334	3002	26.79	262.9	14.5	450	263.45	264.3	50	17950	550	39.2	39.35	400	-11.2	39.3	21.15	112739	2209	13349
78		29654	-8157	82936	25.82	226	15.05	100	225.5	226	50	18000	700	49.9	50	50	-14.05	49.8	20.58	464976	13317	91149
79		4126	-1208	22737	25.19	189	11.85	50	188.6	189	50	18050	50	63.8	63.95	50	-16.25	63.8	19.99	142576	7291	15770
80		44695	-324	201246	24.34	157.1	11.5	100	156.65	157.05	50	18100	250	80.5	80.65	150	-17.85	81	19.77	460001	13100	59174
81		32012	4232	176629	23.65	127	8.9	350	126.6	126.85	50	18150	600	100.65	100.9	350	-20.3	101	19.22	217895	8993	23811
82		124626	1526	707952	22.99	100.1	6.1	850	100	100.15	450	18200	50	124.25	124.45	100	-23.35	124.25	18.57	548798	26000	81699
83		48199	16008	354622	22.68	77.85	3.95	1200	77.85	78.05	250	18250	250	152.05	152.5	50	-26.55	151.85	17.41	179741	6392	11428
84		136762	23510	719823	22.21	58.95	2.15	750	58.95	59.1	350	18300	100	183.65	184	350	-27.05	184	17.02	182238	7407	34237
85		38313	3638	232729	22.12	44.05	0.4	650	43.95	44.05	250	18350	100	219.2	220	50	-27.4	218.15	15.06	21221	486	2723
86		107969	1423	445356	21.92	32.35	-0.5	50	32.35	32.4	50	18400	300	256.8	257.4	50	-30.45	256.4	12.96	36165	1428	17506
87		33323	2463	172881	21.85	23.65	-1.35	750	23.6	23.7	1100	18450	50	298.25	299.5	50	-26.9	300.85	-	4112	-38	1578
88		143923	11845	423217	21.88	17.05	-1.7	5900	17	17.1	2350	18500	400	340.8	341.95	250	-30.95	340.95	-	19424	-1039	30803
89		31030	4664	141255	21.9	12.1	-1.75	5250	12.1	12.2	2150	18550	50	386.15	387.6	50	-31.45	386.55	-	473	-71	1072
90		90452	8563	226918	22.14	8.9	-1.65	3650	8.9	8.95	200	18600	50	434.6	436.05	50	-29.95	433.65	-	4004	1136	17390
91		42537	10259	94029	22.51	6.75	-1.2	600	6.7	6.75	3500	18650	350	479.8	482.95	100	-24.8	482.1	-	92	29	345
92		87123	11298	181289	23.27	5.55	-1.05	3200	5.55	5.6	3800	18700	100	528.6	530.05	50	-18.6	537.8	-	601	-14	1331
93		21562	525	52058	24.2	4.7	-0.65	550	4.65	4.7	1450	18750	200	573.35	587.15	250	-70.25	539.5	-	7	-1	197
94		72321	1545	132718	25.5	4.3	-0.55	5950	4.25	4.3	500	18800	50	626.8	628.5	50	-23.45	632.2	-	369	-15	1209
95		10463	1261	20668	26.74	3.95	-0.35	1700	3.85	3.95	3750	18850	600	673.25	686.7	200	-127.7	580.15	-	11	-1	83
96		67699	-3172	114432	27.99	3.65	-0.45	6450	3.6	3.65	9750	18900	50	725.3	730.1	800	-38.25	721.1	-	31	-2	276
97		6366	342	10449	29.27	3.25	-0.45	2550	3.25	3.3	4750	18950	100	773.85	785.75	200	10.3	793.4	-	43	15	45
98		128369	-13351	116958	30.35	3.05	-0.5	13400	3	3.05	2900	19000	750	824.65	827.95	450	-21.25	830.65	-	1630	-953	7740
99		4036	-230	2299	31.71	2.85	-0.25	50	2.85	2.9	1900	19050	250	868.25	884.25	100	-	-	-	-	-	17
100		34117	-10930	59093	32.7	2.75	-0.15	950	2.75	2.8	5650	19100	250	921.45	934.5	750	-28.9	930.2	-	34	4	108
101		1601	-339	2306	34.19	2.65	-0.25	200	2.65	2.75	50	19150	200	973.1	982.6	200	-	-	-	-	-	13
102		33375	-1899	33018	35.29	2.55	-0.25	6300	2.5	2.55	2750	19200	50	1024.35	1035.3	250	-27.75	1024.25	-	1	-	197
103		1553	27	1232	36.45	2.5	-0.25	50	2.55	2.65	1250	19250	1000	1070.15	1081.1	50	-	-	-	-	-	3
104		31489	-377	21585	37.81	2.45	-0.1	7700	2.4	2.5	10350	19300	50	1121.3	1130.85	200	-64.15	1094.45	-	112	-33	538
105		1348	-39	296	38.81	2.3	-0.25	1150	2.3	2.4	50	19350	50	1164.05	1186.05	2050	-113	1115.9	-	1	-	57
106		13014	-253	14475	40.38	2.35	-0.15	5900	2.35	2.4	5050	19400	400	1204.65	1234.45	50	-94.55	1165.45	-	1	-	369
107		329	-36	207	41.58	2.35	0.05	50	2.1	2.35	50	19450	50	1248.1	1294.15	50	-34.5	1248.1	-	2	-	3
108		81559	-909	52548	42.77	2.25	-0.2	58350	2.25	2.3	14950	19500	50	1322.45	1330.4	50	-16.8	1334.5	-	14	-12	676
109		647	19	345	43.54	2.1	-0.25	1100	2.05	2.25	200	19550	50	1347.9	1410.8	50	-	-	-	-	-	3
110		7503	216	5327	45.1	2.15	-0.1	800	2.1	2.15	250	19600	200	1397.85	1437.2	50	-	-	-	-	-	6
111		514	71	354	46.09	2	-0.1	1200	1.95	2.15	200	19650	50	1447.75	1510.9	50	-	-	-	-	-	1
112		5478	-10	4319	47.65	2.05	-0.05	2050	2	2.1	700	19700	200	1497.7	1540.5	200	-	-	-	-	-	1
113		648	134	381	48.91	1.95	0.35	1200	1.9	1.95	300	19750	50	1560	1589.8	50	-	-	-	-	-	1
114		8036	573	7991	49.87	1.8	-0.1	1050	1.85	1.95	1650	19800	200	1622.2	1633.7	50	-19.2	1601.8	-	7	3	62
115		830	5	59	50.63	1.9	-	200	1.75	1.85	400	19850	1800	1660.95	1691.95	50	-	-	-	-	-	9
116		12726	-276	7318	52.19	1.9	0.1	500	1.9	1.95	1700	19900	100	1711.45	1742.35	200	-	-	-	-	-	4
117		2877	70	368	53.58	1.9	0.3	400	1.9	2	1200	19950	1800	1761.4	1792.4	1800	-	-	-	-	-	1
118		63101	-3957	29817	54.12	1.75	0.05	3500	1.75	1.8	3400	20000	50	1810.4	1833.85	50	-15.55	1830.7	-	10	7	74
Sheet1

 

[bebo021999]

Just paste text code in to cell A1, then using this in B1 and drag accross as far as needed.

TABEL EXAMPLE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	"","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595",""	2,878.00	- 51.00	58.00	202.89	3,935.80	40.65	50.00	3,910.95	3,927.95	50.00	14,250.00	5,050.00	0.40	0.45	7,400.00	0.10	0.40	106.60	2,665.00	- 28.00	8,595.00
Sheet4

Cell Formulas
Range	Formula
B1:Z1	B1	=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,""",""","|"),",",""),"|",REPT(" ",1000),COLUMN(A:A)),"|",REPT(" ",1000),COLUMN(A:A)),1000,1000))+0,"")