- Jan 25, 2022
- Office Version
Hello I have 7 columns of data spanning 3077 rows and I have concenated it to one column to read as an address with phone number and website..each of these having a title in the concenate formula. I need to transfer this data to a CVS form to upload into a map however when I try it reads data as a formula. I need to know how to get it to read as text while keeping the formatting. I know i can paste it into notepad and this will turn it to text then I can paste it back however doing this 3077 times is something I want to avoid. I have done it once however I don't know the exact steps as I tried million things and somehow got it to work but I cant seem to recreate this miracle! Please help!!