=IF(ISNA(MATCH not pulling all info

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
im using the =IF(ISNA(MATCH
to retrieve the information from another cell in a .csv file into a .xls file, however the information its retrieving is getting cut off at 255 characters. is there anyway to get it to retrive all the charachters without getting cut off?
please help this is killing my product descriptions, thank you ahead of time
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
What is the full formula?

What version of Excel do you have?

I don't know what functions you are using to access the CSV file, but don't you think that converting it to an XLS file might help?

I use INDEX(MATCH on external Excel workbooks all the time, ( Excel 97 ), and haven't had problems retrieving information of more than 255 characters.
 

Forum statistics

Threads
1,141,718
Messages
5,708,074
Members
421,545
Latest member
TWR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top