Forum Discussion
Removing Data from one field and moving to another field
Hi there, If there some sort of formula or command that will allow me to strip one part of a field and move it to another one. What I mean is we have a music index program that can export to CSV...
I only want to remove it from the first Column and then move it to a new column. I would prefer not to have the brackets in the first column but if it is difficult to remove them in the new column then that is ok. Unfortunatly I have to say that I am pretty confused on that as I have never ever made a formula before so would not know where to start. The code is ALWAYS the same length. Three letters, and 6 numbers. When I said treat me like I am thick, MORE THICK then that ha ha. Sorry I am a novice on this. Thanks for the message back.
I"m a little confused on what you're saying. Did you open my spreadsheet to see the results it delivers? The reason I sent you what I did was with the expectation that you or somebody else with a tad more knowledge might be able to just use those formulas as a starting point.
In any event, it doesn't look like your spreadsheet contains anything proprietary or confidential: can you just post the whole spreadsheet so I or somebody else can enter the formulas.
- Ok I looked at that works great to copy the code over. I am guessing it is not so easy to be able to remove it from the first field so rather then copy paste it is cut paste. A good start though
Thanks- You can copy from the column where you ran the formula that made the text "clean" and then do a "Paste ....Special" (from the menu at the top of the screen) and select "Values" to paste it on top of Column A.
However, do it with just the first cell the first time to make sure you're doing it right.
- I now have it showing. Thanks. Wierd thing was that when I typed the first few codes it appears that Excel did the rest for me. I just now want to see if I can delete the text from the first field. The would be great then.
- I will try to open again.. When I opened it I got a picture on the screen so maybe I did it wrong.... Will try again
Thanks