info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
file di excel con dati in una sola cella
20 views
Skip to first unread message
CLAUDIA GIACOMOLI
Aug 9, 2021, 9:42:23 AM8/9/21
to
Buongiorno, non so come spiegarmi ma vorrei che i dati del file che qui allego si mettessero nelle giuste celle.
Come si fa?
#,Book Title,Author,Date of publication,Price,Est. Sales,Sales Rev.,Reviews,Sales Rank,ASIN/ISBN-13,Length,Format,Book URL
1,The Complete Ketogenic Diet for Beginners: Your Essential Guide to Living the Keto Lifestyle,Amy Ramos,"December 20, 2016",$3.16,790,"$ 2,496","24,072",4415,B01N9892Q6,162,Kindle,"=HYPERLINK(""https://www.amazon.com/Complete-Ketogenic-Diet-Beginners-Essential-ebook/dp/B01N9892Q6/ref=sr_1_3?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-3"")"
2,The Ketogenic Diet: The Easiest Way To Lose Weight and Get Healthy,Lana Davidson,"
July 27, 2021",$4,2,$ 8,1,1139814,B09BDCPCHH,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Easiest-Weight-Healthy-ebook/dp/B09BDCPCHH/ref=sr_1_4?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-4"")"
3,The Ketogenic Diet For Beginners: The Ultimate Guide To Lose Weight and Get Healthy (Learn Everything That You Need To Know About The Ketogenic Diet),Daniel David,"
July 31, 2021",$3.95,null,$ 0,1,0,B09BMF7V1V,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Beginners-Ultimate-Everything-ebook/dp/B09BMF7V1V/ref=sr_1_5?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-5"")"
4,The Easy 5-Ingredient Ketogenic Diet Cookbook: Low-Carb High-Fat Recipes for Busy People on the Keto Diet,Jen Fisch,"December 26, 2017",$9.93,450,"$ 4,469","12,459",8016,B077Y56PK8,330,Kindle,"=HYPERLINK(""https://www.amazon.com/Easy-5-Ingredient-Ketogenic-Diet-Cookbook-ebook/dp/B077Y56PK8/ref=sr_1_6?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-6"")"
5,Guide to 5 Ingredients Ketogenic Diet For Beginners And Novices : Ketosis is a metabolic state in which your body uses fat for fuel instead of carbs.,Dr Patrick Elliot,"
August 6, 2021",$3.99,null,$ 0,0,0,B09C44T855,167,Kindle,"=HYPERLINK(""https://www.amazon.com/Guide-Ingredients-Ketogenic-Beginners-Novices-ebook/dp/B09C44T855/ref=sr_1_8?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-8"")"
6,"The Complete Guide to the Ketogenic Diet for Women After 50: Useful Tips and 90 Delectable Recipes| 30-Day Keto Meal Plan to Shed Weight Heal Your Body, and Regain Confidence",Sandra Grant,"
August 19, 2020",$5.87,12,$ 70,539,232482,B08GCVYL1Z,208,Kindle,"=HYPERLINK(""https://www.amazon.com/Complete-Guide-Ketogenic-Women-After-ebook/dp/B08GCVYL1Z/ref=sr_1_9?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-9"")"
7,Essential Ketogenic Mediterranean Diet Cookbook: 100 Low-Carb Heart-Healthy Recipes for Lasting Weight Loss,Molly Devine RD,"February 4, 2020",$9.93,107,"$ 1,063",438,32948,B083VWR4C3,306,Kindle,"=HYPERLINK(""https://www.amazon.com/Essential-Ketogenic-Mediterranean-Diet-Cookbook-ebook/dp/B083VWR4C3/ref=sr_1_10?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-10"")"
8,KETOGENIC DIET FOR DIABETES : COMPREHENSIVE GUIDE PLUS LOW CARB RECIPES FOR ALL TYPES OF DIABETES,LINDA LYNN PH.D,"
August 7, 2021",$3.99,null,$ 0,0,0,B09C4GWCDH,147,Kindle,"=HYPERLINK(""https://www.amazon.com/KETOGENIC-DIET-DIABETES-COMPREHENSIVE-RECIPES-ebook/dp/B09C4GWCDH/ref=sr_1_11?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-11"")"
9,The Ketogenic Bible: The Authoritative Guide to Ketosis,Jacob WilsonRyan Lowery,"August 15, 2017",$11.75,16,$ 188,953,184087,B0744GMHSQ,384,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Bible-Authoritative-Guide-Ketosis-ebook/dp/B0744GMHSQ/ref=sr_1_13?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-13"")"
10,Keto Diet For Beginners 2021: The Ultimate Ketogenic Diet Guide For Beginners (Everything You Need To Know About The Ketogenic Diet),Taylor Davidson,"
July 28, 2021",$3.95,85,$ 336,3,40878,B09BG2JGCX,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Beginners-2021-Everything-ebook/dp/B09BG2JGCX/ref=sr_1_14?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-14"")"
11,Ketogenic Diet on a Budget,Wes Shoemaker,"July 27, 2021",$6.92,430,"$ 2,976",33,8402,B0997X5FZJ,NaN,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Budget-Wes-Shoemaker-ebook/dp/B0997X5FZJ/ref=sr_1_15?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-15"")"
12,The Ketogenic Diet: A Scientifically Proven Approach to Fast Healthy Weight Loss,Kristen Mancinelli,"January 6, 2015",$15.63,16,$ 250,197,181749,B00R3L72F0,268,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Scientifically-Approach-Healthy-ebook/dp/B00R3L72F0/ref=sr_1_16?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-16"")"
13,Ketogenic diet for beginners and professionals: Basics - tips & tricks - recipes theory & cookbook incl. 14-day nutrition plan,Sandra Grant,"
August 7, 2021",$3.16,null,$ 0,0,0,B09C4X16NF,161,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-diet-beginners-professionals-nutrition-ebook/dp/B09C4X16NF/ref=sr_1_18?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-18"")"
14,Keto: The Complete Guide to Success on The Ketogenic Diet including Simplified Science and No-cook Meal Plans (Keto: The Complete Guide to Success on the Ketogenic Diet Series),Maria EmmerichCraig Emmerich,"January 9, 2018",$11.75,42,$ 494,"1,791",77644,B078QXR211,384,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Complete-Ketogenic-including-Simplified-ebook/dp/B078QXR211/ref=sr_1_19?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-19"")"
15,Keto Diet for Women Over 50: The Complete Guide for Beginners to Lose Weight Fast Following the Revolutionary Ketogenic Diet. 200+ Tastiest and Easiest Recipies and a 28 Day Meal Plan,KATRINA WILLIAMS,"
December 30, 2020",$8.23,9,$ 74,40,296649,B08RSMP1RD,285,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Women-Over-Revolutionary-ebook/dp/B08RSMP1RD/ref=sr_1_20?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-20"")"
16,Keto Comfort Foods (Keto: The Complete Guide to Success on the Ketogenic Diet Series),Maria Emmerich,"May 2, 2017",$11.75,40,$ 470,"4,638",80741,B06ZZMRP4N,598,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Comfort-Foods-Maria-Emmerich-ebook/dp/B06ZZMRP4N/ref=sr_1_21?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-21"")"
17,"Keto Diet Recipes, Benefits & Cons: Ketogenic Diet",Steven Harrison,"
August 5, 2021",$8.99,null,$ 0,0,0,B09C2WMZDT,NaN,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Recipes-Benefits-Cons-ebook/dp/B09C2WMZDT/ref=sr_1_20?dchild=1&keywords=KETOGENIC+DIET&qid=1628515331&s=digital-text&sr=1-20"")"
Grazie
Come si fa?
#,Book Title,Author,Date of publication,Price,Est. Sales,Sales Rev.,Reviews,Sales Rank,ASIN/ISBN-13,Length,Format,Book URL
1,The Complete Ketogenic Diet for Beginners: Your Essential Guide to Living the Keto Lifestyle,Amy Ramos,"December 20, 2016",$3.16,790,"$ 2,496","24,072",4415,B01N9892Q6,162,Kindle,"=HYPERLINK(""https://www.amazon.com/Complete-Ketogenic-Diet-Beginners-Essential-ebook/dp/B01N9892Q6/ref=sr_1_3?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-3"")"
2,The Ketogenic Diet: The Easiest Way To Lose Weight and Get Healthy,Lana Davidson,"
July 27, 2021",$4,2,$ 8,1,1139814,B09BDCPCHH,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Easiest-Weight-Healthy-ebook/dp/B09BDCPCHH/ref=sr_1_4?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-4"")"
3,The Ketogenic Diet For Beginners: The Ultimate Guide To Lose Weight and Get Healthy (Learn Everything That You Need To Know About The Ketogenic Diet),Daniel David,"
July 31, 2021",$3.95,null,$ 0,1,0,B09BMF7V1V,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Beginners-Ultimate-Everything-ebook/dp/B09BMF7V1V/ref=sr_1_5?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-5"")"
4,The Easy 5-Ingredient Ketogenic Diet Cookbook: Low-Carb High-Fat Recipes for Busy People on the Keto Diet,Jen Fisch,"December 26, 2017",$9.93,450,"$ 4,469","12,459",8016,B077Y56PK8,330,Kindle,"=HYPERLINK(""https://www.amazon.com/Easy-5-Ingredient-Ketogenic-Diet-Cookbook-ebook/dp/B077Y56PK8/ref=sr_1_6?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-6"")"
5,Guide to 5 Ingredients Ketogenic Diet For Beginners And Novices : Ketosis is a metabolic state in which your body uses fat for fuel instead of carbs.,Dr Patrick Elliot,"
August 6, 2021",$3.99,null,$ 0,0,0,B09C44T855,167,Kindle,"=HYPERLINK(""https://www.amazon.com/Guide-Ingredients-Ketogenic-Beginners-Novices-ebook/dp/B09C44T855/ref=sr_1_8?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-8"")"
6,"The Complete Guide to the Ketogenic Diet for Women After 50: Useful Tips and 90 Delectable Recipes| 30-Day Keto Meal Plan to Shed Weight Heal Your Body, and Regain Confidence",Sandra Grant,"
August 19, 2020",$5.87,12,$ 70,539,232482,B08GCVYL1Z,208,Kindle,"=HYPERLINK(""https://www.amazon.com/Complete-Guide-Ketogenic-Women-After-ebook/dp/B08GCVYL1Z/ref=sr_1_9?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-9"")"
7,Essential Ketogenic Mediterranean Diet Cookbook: 100 Low-Carb Heart-Healthy Recipes for Lasting Weight Loss,Molly Devine RD,"February 4, 2020",$9.93,107,"$ 1,063",438,32948,B083VWR4C3,306,Kindle,"=HYPERLINK(""https://www.amazon.com/Essential-Ketogenic-Mediterranean-Diet-Cookbook-ebook/dp/B083VWR4C3/ref=sr_1_10?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-10"")"
8,KETOGENIC DIET FOR DIABETES : COMPREHENSIVE GUIDE PLUS LOW CARB RECIPES FOR ALL TYPES OF DIABETES,LINDA LYNN PH.D,"
August 7, 2021",$3.99,null,$ 0,0,0,B09C4GWCDH,147,Kindle,"=HYPERLINK(""https://www.amazon.com/KETOGENIC-DIET-DIABETES-COMPREHENSIVE-RECIPES-ebook/dp/B09C4GWCDH/ref=sr_1_11?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-11"")"
9,The Ketogenic Bible: The Authoritative Guide to Ketosis,Jacob WilsonRyan Lowery,"August 15, 2017",$11.75,16,$ 188,953,184087,B0744GMHSQ,384,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Bible-Authoritative-Guide-Ketosis-ebook/dp/B0744GMHSQ/ref=sr_1_13?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-13"")"
10,Keto Diet For Beginners 2021: The Ultimate Ketogenic Diet Guide For Beginners (Everything You Need To Know About The Ketogenic Diet),Taylor Davidson,"
July 28, 2021",$3.95,85,$ 336,3,40878,B09BG2JGCX,59,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Beginners-2021-Everything-ebook/dp/B09BG2JGCX/ref=sr_1_14?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-14"")"
11,Ketogenic Diet on a Budget,Wes Shoemaker,"July 27, 2021",$6.92,430,"$ 2,976",33,8402,B0997X5FZJ,NaN,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Budget-Wes-Shoemaker-ebook/dp/B0997X5FZJ/ref=sr_1_15?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-15"")"
12,The Ketogenic Diet: A Scientifically Proven Approach to Fast Healthy Weight Loss,Kristen Mancinelli,"January 6, 2015",$15.63,16,$ 250,197,181749,B00R3L72F0,268,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-Diet-Scientifically-Approach-Healthy-ebook/dp/B00R3L72F0/ref=sr_1_16?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-16"")"
13,Ketogenic diet for beginners and professionals: Basics - tips & tricks - recipes theory & cookbook incl. 14-day nutrition plan,Sandra Grant,"
August 7, 2021",$3.16,null,$ 0,0,0,B09C4X16NF,161,Kindle,"=HYPERLINK(""https://www.amazon.com/Ketogenic-diet-beginners-professionals-nutrition-ebook/dp/B09C4X16NF/ref=sr_1_18?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-18"")"
14,Keto: The Complete Guide to Success on The Ketogenic Diet including Simplified Science and No-cook Meal Plans (Keto: The Complete Guide to Success on the Ketogenic Diet Series),Maria EmmerichCraig Emmerich,"January 9, 2018",$11.75,42,$ 494,"1,791",77644,B078QXR211,384,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Complete-Ketogenic-including-Simplified-ebook/dp/B078QXR211/ref=sr_1_19?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-19"")"
15,Keto Diet for Women Over 50: The Complete Guide for Beginners to Lose Weight Fast Following the Revolutionary Ketogenic Diet. 200+ Tastiest and Easiest Recipies and a 28 Day Meal Plan,KATRINA WILLIAMS,"
December 30, 2020",$8.23,9,$ 74,40,296649,B08RSMP1RD,285,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Women-Over-Revolutionary-ebook/dp/B08RSMP1RD/ref=sr_1_20?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-20"")"
16,Keto Comfort Foods (Keto: The Complete Guide to Success on the Ketogenic Diet Series),Maria Emmerich,"May 2, 2017",$11.75,40,$ 470,"4,638",80741,B06ZZMRP4N,598,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Comfort-Foods-Maria-Emmerich-ebook/dp/B06ZZMRP4N/ref=sr_1_21?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-text&sr=1-21"")"
17,"Keto Diet Recipes, Benefits & Cons: Ketogenic Diet",Steven Harrison,"
August 5, 2021",$8.99,null,$ 0,0,0,B09C2WMZDT,NaN,Kindle,"=HYPERLINK(""https://www.amazon.com/Keto-Diet-Recipes-Benefits-Cons-ebook/dp/B09C2WMZDT/ref=sr_1_20?dchild=1&keywords=KETOGENIC+DIET&qid=1628515331&s=digital-text&sr=1-20"")"
Grazie
Ammammata
Aug 9, 2021, 10:26:16 AM8/9/21
to
Il giorno Mon 09 Aug 2021 03:42:21p, *CLAUDIA GIACOMOLI* ha inviato su
microsoft.public.it.office.excel il messaggio
news:a8784ad0-c8df-4313...@googlegroups.com. Vediamo
cosa ha scritto:
> Buongiorno, non so come spiegarmi ma vorrei che i dati del file che
> qui allego si mettessero nelle giuste celle. Come si fa?
>
> #,Book Title,Author,Date of publication,Price,Est. Sales,Sales
> Rev.,Reviews,Sales Rank,ASIN/ISBN-13,Length,Format,Book URL 1,The
> Complete Ketogenic Diet for Beginners: Your Essential Guide to Living
> the Keto Lifestyle,Amy Ramos,"December 20, 2016",$3.16,790,"$
> 2,496","24,072",4415,B01N9892Q6,162,Kindle,"=HYPERLINK(""https://www.am
> azon.com/Complete-Ketogenic-Diet-Beginners-Essential-ebook/dp/B01N9892Q
> 6/ref=sr_1_3?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-
> text&sr=1-3"")"
>
a prima vista si direbbero "comma separated values" con le virgolette come
delimitatori del testo (nel caso questi includa una virgola)
quindi, una volta selezionate le celle, si usa la procedura guidata "testo
in colonne" nel menu Dati
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
microsoft.public.it.office.excel il messaggio
news:a8784ad0-c8df-4313...@googlegroups.com. Vediamo
cosa ha scritto:
> Buongiorno, non so come spiegarmi ma vorrei che i dati del file che
> qui allego si mettessero nelle giuste celle. Come si fa?
>
> #,Book Title,Author,Date of publication,Price,Est. Sales,Sales
> Rev.,Reviews,Sales Rank,ASIN/ISBN-13,Length,Format,Book URL 1,The
> Complete Ketogenic Diet for Beginners: Your Essential Guide to Living
> the Keto Lifestyle,Amy Ramos,"December 20, 2016",$3.16,790,"$
> 2,496","24,072",4415,B01N9892Q6,162,Kindle,"=HYPERLINK(""https://www.am
> azon.com/Complete-Ketogenic-Diet-Beginners-Essential-ebook/dp/B01N9892Q
> 6/ref=sr_1_3?dchild=1&keywords=KETOGENIC+DIET&qid=1628515329&s=digital-
> text&sr=1-3"")"
>
delimitatori del testo (nel caso questi includa una virgola)
quindi, una volta selezionate le celle, si usa la procedura guidata "testo
in colonne" nel menu Dati
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
CLAUDIA GIACOMOLI
Aug 9, 2021, 3:10:43 PM8/9/21
to
Zipper
Aug 9, 2021, 5:30:45 PM8/9/21
to
CLAUDIA GIACOMOLI ha usato la sua tastiera per scrivere :
copia il file in NOTEPAD
sostituisci le virgole col punto e virgola
sostituisci gli uguali con niente
magari cancelli le parole HYPERLINK
Salvi tutto come Nome.csv, e poi magari ci giochi col formato XLS
aggiustando le colonne
sostituisci le virgole col punto e virgola
sostituisci gli uguali con niente
magari cancelli le parole HYPERLINK
Salvi tutto come Nome.csv, e poi magari ci giochi col formato XLS
aggiustando le colonne
Ammammata
Aug 10, 2021, 5:25:25 AM8/10/21
to
Il giorno Mon 09 Aug 2021 09:10:42p, *CLAUDIA GIACOMOLI* ha inviato su
microsoft.public.it.office.excel il messaggio
news:29a1ffa7-e9c8-4af1...@googlegroups.com. Vediamo
cosa ha scritto:
> GRazie! Help, mettendo il separatore "virgola" mi esce un pasticcio:
> che passaggi dovrò usare?
Hai impostato il delimitatore di testo " ? ho visto che ci sono virgole
sparse qua e là che causano un disallineamento
microsoft.public.it.office.excel il messaggio
news:29a1ffa7-e9c8-4af1...@googlegroups.com. Vediamo
cosa ha scritto:
> GRazie! Help, mettendo il separatore "virgola" mi esce un pasticcio:
> che passaggi dovrò usare?
sparse qua e là che causano un disallineamento
0 new messages