Copying Columns of Text - WS Functions do not work correctly

D

Dixfield Guy

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 - -
 
E

Elkar

Make sure that Automatic Calculations are turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy text into blank rows 2
get a cell reference as a result of an If Function 1
copy specific cells from sheets if the information is correct 3
Remove certain characters from a text string 6
Excel function - countif 2
Function to evaluate function as string 3
Function on "Text to Columns" 3
Help with function 2

Top