I have a large list of coins I need to edit. The list is set up so COLUMN-A contains the dates w/mintmarks, COL-B displays the amount minted, etc. What I need help with is to separate COL-A into two columns: COL-A: 'Coin Date' and COL-B: 'Mintmark'. So if a single cell from COL-A originally displays "1889 S", I need the end result to display only "1889" in COL-A and only "S" in COL-B. Thanks for any help.
Select the col of data, then Click Data > Text to Columns > Delimited > Check "Space" > Finish
---------------------------
Any good? Wave it, click on the little star at the bottom left of my responses
Hi and welcome to the forum
IF you use T2C as suggested above, make sure you insert a new column between A and B 1st, or the T2C may replace the data you have in B
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Beautiful! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks