How do I split Column A in list below so only B remains:
A B
P/D15/COR15 COR15
N/D156/15/FORT001 FORT001
How do I split Column A in list below so only B remains:
A B
P/D15/COR15 COR15
N/D156/15/FORT001 FORT001
I think we need a few more examples than that - please attach a sample Excel workbook with some more examples of what is in column A.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.
Hope this helps.
Pete
File attached
How aboutFormula:Please Login or Register to view this content.
Hi there,
There is a Youtube channel called: ExcelIsFun,
He has a video series called: Excel Basics: Learn to Efficiently Use Excel at Work and to Get a Job (25 videos)
The last video (25th) describes a really good method for this!
Check out the channel, the guy is really good!
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
array formula CSE
=REPLACE(A2,1,MAX(IF(MID(A2,ROW($A$1:$A$100),1)="/",ROW($A$1:$A$100))),)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks