split cell value

Hi Friends, I am trying to achieve something like this using VBA: I have some sentences in first columns as mentioned below and would like to split them into just two cells. <tbody> <colgroup><col width="170"></colgroup><tbody> Text </tbody> <colgroup><col...

Hi all, I want to split text in multiple rows using formula. In Colomn A is the raw data which I want to split so that I can get only data that I need. Example data I need is in colomn B and C. Can you please help? Thanks Al <tbody> A B C String Text To be shown To be shown MC3496 AFC285...

Hi there I'm an undergrad using Excel for Mac 2011 working in a university lab and am having lots of trouble trying to calculate what fraction of each hour a fish spends in a certain swim chamber. I have been able to calculate the proportion per hour using Pivot tables and it's working alright...

Dear All I have some spreadsheets containing substantial rows of data, basically 3 columns as this: <tbody> Sample Start End Difference (End-Start) A 1500 1600 100 B 1200 1260 60 C 960 1020 60 D 900 920 20 </tbody> And what i want to obtain is different rows of data such...

Hi all, Please help me on this: I want to have a formula in cell “B10” that checks the number of characters in cell “A1” that contain say for example the text string “One Thousand Five Hundred Twenty Five”. When the number of characters exceeds the maximum of 20, it will trim the result to 20...