Hi - I have about 6000 rows of data, the first colunm is the site name. Data in the cells range from 12 characters to less than 8 characters. I would like to split the text in the first column based on the last 8 characters. I thought 'fixed width' in 'text to columns' would be worth persuing, but I need the last 8 characters (and fixed width starts from the front of the text) - anyone have any ideas?
Assuming data is in colun A
Enter this formula B1
=RIGHT(A1,8)
Copy formula down to last used row
Select Column
Copy
PasteSpecial - Value
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
What if you need it to take the last 8 characters from A1 and put it into B1 and not just copy it?
adfeddon,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks