Copying Columns of Text - WS Functions do not work correctly
 

I have a strange situation. Excel 2003, I convert dbf tables to cvs and then
to xls using the ABC converter. When I attempt to use a text function (LEFT,
RIGHT, MID, etc) to find a string the function will not recognize the string
or partial string. Secondly, I insert a column next to the column with my
text and attempt to copy the text into the inserted column (B) using the
simple =A1 function, the first cell (B1) copies correctly. However, when I
then attempt to copy the =A1 into the B2 cell I get the A1 contents as if the
function in B1 is =$A$1 (absolute). I usually have a terrible time with text
fields in Excel and am at a loss. I have researched this extensively and have
tried the usual to no avail. If anyone has any ideas or can send me somewhere
for help I would greatly appreciate it. Thanks ahead - -

Copying Columns of Text - WS Functions do not work correctly
 

Make sure that Automatic Calculations are turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"

HTH,
Elkar


"Dixfield Guy" wrote:

I have a strange situation. Excel 2003, I convert dbf tables to cvs and then
to xls using the ABC converter. When I attempt to use a text function (LEFT,
RIGHT, MID, etc) to find a string the function will not recognize the string
or partial string. Secondly, I insert a column next to the column with my
text and attempt to copy the text into the inserted column (B) using the
simple =A1 function, the first cell (B1) copies correctly. However, when I
then attempt to copy the =A1 into the B2 cell I get the A1 contents as if the
function in B1 is =$A$1 (absolute). I usually have a terrible time with text
fields in Excel and am at a loss. I have researched this extensively and have
tried the usual to no avail. If anyone has any ideas or can send me somewhere
for help I would greatly appreciate it. Thanks ahead - -

Copying Columns of Text - WS Functions do not work correctly
 

Thanks Elkar!! That was it. Grately appreciated - Dixfield Guy

"Elkar" wrote:

Make sure that Automatic Calculations are turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"

HTH,
Elkar


"Dixfield Guy" wrote:

I have a strange situation. Excel 2003, I convert dbf tables to cvs and then
to xls using the ABC converter. When I attempt to use a text function (LEFT,
RIGHT, MID, etc) to find a string the function will not recognize the string
or partial string. Secondly, I insert a column next to the column with my
text and attempt to copy the text into the inserted column (B) using the
simple =A1 function, the first cell (B1) copies correctly. However, when I
then attempt to copy the =A1 into the B2 cell I get the A1 contents as if the
function in B1 is =$A$1 (absolute). I usually have a terrible time with text
fields in Excel and am at a loss. I have researched this extensively and have
tried the usual to no avail. If anyone has any ideas or can send me somewhere
for help I would greatly appreciate it. Thanks ahead - -