formatting the cells without losing certain data

[Bonn K]

I have to enter results from a survey into an excel database. There is a coding system that I have to go by. A couple of participants in the survey entered more than one answer for certain questions but the cell formatting only allows for one value to be entered in the cell therefore the second answer is lost. How can i accomodate for this without losing data and destroying the function and purpose of the survey?

I really would appreciate any help that you could give me.

BK

 

[Yogi Anand]

Hi BK:

Welcome to MrExcel Board!

Your description is very clear. However, it is hard to visualize what you are working with, what and how you are formating -- and how the second answer gets lost.

How about posting some sample data, explaining how you are working with it -- using HTMLmaker (Colo's Cool utility) downloadable from the bottom of this MrExcel page -- and then let us take it from there.

 

[Bonn K]

Yogi,

I downloaded the stuff and I pasted the html code onto here but it doesnt come out?! Help please!

 

[Yogi Anand]

Hi BK:

If you downloaded the HTMLmaker successfully, it would have been installed as an Add-in in your EXCEL application -- and you will see a menu item HTML next to Help on the main menu bar. But it appears that you have got it successfully installed -- but I thought just in case.

Now with HTMLmaker having been successfully installed, you select part of the worksheet that you want to convert to HTML, click on the HTML in menu bar, and there are clear instructions from there on. Please note that in your post you will not see the data you are trying to post, you will see JavaScript code.

If you have additional questions, there are a number of posts regarding the use of HTMlmaker on the Board -- you may want to search for those and look at them. Good Luck!

 

[Bonn K]

Yogi,

I paste the HTML code and when I submit it, all i see is a big blank, i've done everythign the instructions have told me to do but i still have no luck

 

[Yogi Anand]

Hi BK:

As I suggested earlier, do a search on the Board for Colo's Cool utility, or HTMlmaker and see if you can find an answer in one of those posts -- and if you can not resolve that, send me a PM, and I will give you my email address so if you want to you can email me part of your worksheet.

 

[Bonn K]

Thanks yogi