Forum Discussion
AGRSFH
Apr 14, 2022Copper Contributor
Need Help Formatting Data in Excel for a CSV Upload
I've searched and searched but I am unable to find a solution. I have data in an Excel spreadsheet that I need to format a certain way. I need to reference other cells to format data a certain way in the F column.
I need the F column to format exactly "-{C2~C2~D2~E2~~}" where C2 stands for the data thats in cell C2, D2 stands for the data in cell D2, and so on. Cell F2 is an example of what I need the exact text to look like. Ordinarily I would just do this manually but this sheet has over 15 thousand lines in it. Im trying to find a faster way. I know Im probably not explaining this very well but hopefully some will understand what Im trying to do.
2 Replies
- MindreVetandeIron Contributor="-{"&C2&"~"&C2&"~"&D2&"~"&E2&"~~}"
- AGRSFHCopper ContributorYou are a lifesaver. Thank you!