Forum Discussion
Implicit intersection operator: @
Hi, I'm trying to figure out the new implicit operator @ changes. I have .txt files that I pull into excel as part of a regular reports I run. Several of the values did (and should) report a value starting with the @ symbol and followed by a 7 digit number (ex. @5036664 or @11055464) but the @ symbol is no longer showing up in the cell due to these new changes. The formula bar shows =@5036664 but the cell is just 5036664 for all values. I'm not sure how to fix this but the @ symbol is very important to what I'm doing. I currently run the formatting via macro so preference is that I can add something into VBA to fix this.
Note: I'm not an IT professional but am self-taught and pretty proficient.
Thanks so much!
2 Replies
It's better to import such fields as text as JKPieterse suggested, but if correct already imported data you may replace (Ctrl+H) =@ on '@
KatieBSc Can you perhaps upload one of those txt files from which you've replaced sensitive information with nonsense? We only need like 2 or 3 rows of data. IN the mean time, read this: https://jkp-ads.com/articles/importtext.asp for a way to import a textfile and set the datatype of each column. Set the column with the @ as text and it should work.
