Hoping you could. Newbie here.
I have a list of software name with its version (Column A) and I need to separate the software name (column B) and the version (column C). I tried using a delimiter but would not work because the data in column A is complex. Would you be able to advise the best way to do this? I do not want to do it manually as the list contains around 8000 rows. I have attached a part of the list, for your reference.
Thank you in advance.
You are not new here - you signed up in 2020!
Are you still using Excel 2016? If not, please update your forum profile.
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.
will the version always be after the last space in the text string
thats how it appears in ALL the examples
for software
=LEFT(A2,FIND("/", SUBSTITUTE(A2," ","/", LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))
for version
=RIGHT(A2,LEN(A2)-FIND("/",SUBSTITUTE(A2," ","/",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Apologies, I am now using Office 365.
Newbie in excel I mean, sorry
For 365:
=TEXTBEFORE(A2:A12," ",-1)
and:
=TEXTAFTER(A2:A12," ",-1)
Power Query
Please Login or Register to view this content.
Single formula in H2
Formula:
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 04-01-2024 at 11:02 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks