LinkBack URL
About LinkBacks
Hello all,
I need to split a column at the first dot (.) delimiter.
| CO.Q5.CAO.RFL.CAO | -> | CO | Q5.CAO.RFL.CAO |
| CO.Q4 | -> | CO | Q4 |
ETC.
Hello all,
I need to split a column at the first dot (.) delimiter.
| CO.Q5.CAO.RFL.CAO | -> | CO | Q5.CAO.RFL.CAO |
| CO.Q4 | -> | CO | Q4 |
ETC.
maybe put this formula in column B (assuming your data in in column A)
=LEFT(A1,FIND(".",A1)-1)&"?"&RIGHT(A1,LEN(A1)-FIND(".",A1))
this will replace the first "." with a "?"
drag down for all entries in A
then copy and paste column B as values
then text to columns using ? as the delimiter
Happy with my advice? Click on the * reputation button below
Or in B1 use:
Formula:
Please Login or Register to view this content.
And in C1 use:
Formula:Please Login or Register to view this content.
Then copy down as necessary.
BSB
Good one. I outsmarted myself thinking I had to find a way to delimit this.
Thanks guys!
But is there a VBA way to do this?
Yes, but it is difficult to see in text format. Please attach a sample excel book with desired result
Assuming your data starts in A1:
BSB
Please Login or Register to view this content.
Does this help?
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 06-07-2016 at 08:16 AM.
Or this?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks