convert data

I'm still looking for some help with what at first sight looks like some simple data manipulation but it has me stumped! :confused: I have data on books and authors, like this: Author1 Book1 Author1 Book2 Author1 Book3 Author2 Book1 Author2 Book3 Author2 Book4 Author3 Book5 Author3 Book6...

Hello Guys I've tried and tried ... Searched and searched but couldn't find a solution.. So asking here to the experts... <tbody> A B 2016-02-2413:40:31 2/24/16 1:40 PM 2016-02-2413:36:05 <tbody> 2/24/16 1:36 PM </tbody> 2016-02-2413:40:08 2/24/16 1:40 PM 2016-02-2413:40:09...

Hi everybody, I'm new to this forum and excel for that matter and have been going crazy trying to figure something out that's probably very simple. I have a column with a bunch of birthweights in the following form "7 lb 1.1 oz" and would like to convert it in another cell into grams (i.e. 7 lb...

Hi GuysI really need your help please.My Excel knowledge is very limited if it comes to this I have data in a sheet which we currently manually capture in another systemThe data however is in the wrong format for bulk uploading.Would you please advise who I can attache a file to a post so that I...

Hello, everyone! I hope you are having a great day today! I am trying to manipulate data downloaded from a bank file into a useable format. What adds a level of difficulty is that I am trying to do this for someone who has almost zero Excel knowledge so I'm trying to automate this as much as...

Hello All, I need some help to convert a list of 40000 items to a specific format in Excel. I have a colum with the following data LFO1066A LFTF105 PTXTAA103 They need to be converted to the following format <TBODY> A B C D E F LFO1066A L FO 1066 / A LFTF105 L FTF 0105...