Thread: Import BV Prices Question
10-20-2012, 01:28 AM #1
Import BV Prices Question
I am trying to add the BV prices to my inventory by using the 3rd party importer.
The problem I am having is all my data is in Excel
I have listed 1 full set of 190 cards as a trial for myself but the importer did not want to except my list
Example of my list
1 (TAB) $5.00
2 (TAB) $2.00
3 (TAB) $25.00
This was not imported
I had to remove the TAB SPACE to make it look like this
Now my question is
Is there a way to remove that TAB space in bulk or a way to allow the importer to accept it?
Last edited by gary991979; 10-20-2012 at 01:31 AM.Hidden Content Hidden Content
05-06 The Cup 34/191 = 17.80% 06-07 The Cup 26/174 = 14.94% 07-08 The Cup 47/190 = 24.74%
08-09 The Cup 52/150 = 34.67% 09-10 The Cup 92/180 = 51.11% 10-11 The Cup 148/180 = 82.22%
11-12 The Cup 9/180 = 5.00% 10-11 Dominion 233/250 = 93.20% 11-12 Dominion 25/199 = 12.56%
Private Signings Set 64/325 = 19.69% 2011-12 Panini Prime 103/166 = 62.04%
10-20-2012, 11:19 AM #2
Depending on the version of excel, there will be a feature called text to columns. My 2007 excel on my work computer had it under Data. In that option you could set it to create a column in place of the tab. That may not have the desired effect though.
Alternatively, you could copy and paste into notepad and use the replace option to replace tab with a single space or whatever you needed.Markus Naslund Collector