Hello Experts
I have some data which I need to sort in separate column by 'FORMULA'.
In the attached file -
In column A data is given; I want the account no. B and Account title in Column C
Thanking Advance
rif
Hello Experts
I have some data which I need to sort in separate column by 'FORMULA'.
In the attached file -
In column A data is given; I want the account no. B and Account title in Column C
Thanking Advance
rif
Last edited by rif; 12-29-2019 at 04:05 PM.
Cell B2 formula: =Left(A2,11)
Cell C2 forumla: =MID(A2,13,LEN(A2)-13)
Then copy down as far as needed
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Another option if the account numbers are not always 12 digits
=LEFT(A2,FIND(" ",A2)-1)+0
and
=TRIM(SUBSTITUTE(A2,B2,""))
Remove the +0 from the first formula if you want the account number as text
Thank you JLGWhiz.
It's work great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks