Valor Talk

Lately, I have been working on trying to update my inventory a variety of ways, and I keep running into the same problem.  The description fields in the Valor inventory spreadsheet has extra carriage returns and/or linefeeds that are wreaking havoc with my ability to save the document as a CSV file.  Can you look into the CR/LF setup on the inventory spreadsheet to see if there is anything that can be done?  For instance, take a look at model number 2150683.  The description for this item in the spreadsheet looks like:

- - - -

Hunters, backpackers, birders and others who require long range optics in remote areas will appreciate Simmons line of lightweight, easy to carry spotting scopes.  The clarity and brightness of these spotting scopes make them equally suitable for the field,shooting range, home, and for other surveillance needs.

RedLine 10-60x60mm  Black, Case and Tripod included  Weight-52 oz  Length - 20.75

- - - - 

The linefeeds between the words "needs." and "RedLine" are the problem.  Can these somehow be stripped from the spreadsheet?  If I could find a way to do it myself, I would...but since I can't seem to come up with a good way to do it, I'm hoping that it can be taken care of when the spreadsheet is generated.

Thanks!

Rick
 

alright...I have been working on this off and on for days...and I think I figured out a way to replace those pesky CR/LF in excel.

Create a new spreadsheet and copy the description column over to it.  Then, in the column next to it, enter the following, where A2 in the statement below is the cell that you want to remove CR/LF from.

=SUBSTITUTE(SUBSTITUTE(A2, CHAR(10), ' '), CHAR(13), ' ')

This will replace all CR/LF with a space.  Save the new spreadsheet as tab-delimited .txt, then reopen in the excel session that your 

original spreadsheet is currently open (this allows copy/paste operations to exceed 255 characters...if the workbook is open in a 

different excel session, the fields get truncated when you copy/paste them over).  By saving the document to text format, it forces the cells 

to save with the text in them, thus removing the formula. 

Now, you should just be able to copy/paste from one workbook to the other and Voila!