Strange Vlookup result - baffled

Your Data in Sheets "Prices" Column A has trailing carriage returns (or line feeds?) i.e. Char(10)

Put this in K2

Please Login or Register  to view this content.

Drag/Fill Down
Then copy the result and Paste Special > Values to A2.

select col a on sheet prices
then from data tab select text to columns
select delimited click next
click other click in the box next to other and do ctrl+j youll see a new dividing line appear in the preview box below
click next
in the preview pane you should see two columns headed general separted by a divider
click on the second "general" to select the column heading
above it click the "do not import this column (skip)" option
the preview will show "general" and "skip column"
click finish

Or select the whole table, Ctrl+H, click in the Find box and press Ctrl+J, then with the Replace box blank, press Replace All.

i already tried thatbut putting ctrl+j in find doesnt do it , i get a . appear and it can find nothing to replace i also tried alt+010 and alt+0010 neither worked

Works fine in 2010. You can also use Alt+0010 on the number keypad, or just copy one of the characters and paste it in.

i must admit ive noticed this before and never got to the bottom of it, sometimes typing in alt+0010 on number pad works just fine other times it doesnt, even tho its the same thing to be removed and i know i have used ctrl+j in the past!