I tried to import an excel csv file that had cells based on two others: A1 = B1&B2 for example. But RS5000 rejected the "result" (A1 etc) cells. Is there a way in excel that I can strip-out the formula content of a cell so that it's just text again? I used the drag auto increment fuction in excel as my base tag was "AV01 Alarm Timer" and I have a lot of them to type. So I created the first tag comment in RS5000 and separated the "AV01" and "Alarm Timer" halves in excel, generated a range then merged them again using A1 = B1&B2 etc. Clear as mud? Thanks.
A bit ot; Excel file tricks and RS5000
- Thread starter DairyBoy
- Start date
OkiePC
Lifetime Supporting Member
After you get the results in your cells how you want them, select the section you want to strip out the formulas, copy (CTRL+C), then Paste Special (right click or Edit menu) and choose the Values radio button. This will effectively paste the results of the formulas in place of the formulas themselves.
Then do a save as .csv before importing.
Then do a save as .csv before importing.
Similar Topics
Hi,
I'm just looking for a simple way to make a button in excel (via VBA I presume) to toggle a bit in RSLogix 5000. I just got FactoyTalkLinx...
I'm looking for a fast easy Excel code to move whole integer values into separate bit fields. Does anyone know of a relatively easy code?🔨
Hi,
I use Excel to edit Symbol list, alarm list etc. This to speed up making HMI and PLC projects.
But a small thing is irritating me beyond...
Which format would be easier for other techs to decipher and also be portable?
Taking an integer and breaking it down to it's binary equivalent...
See the screenshot of EIP tag list. We are trying to read in a digital input that is hard-wired. It is shown here as I31.1. I believe we cannot...