I have 800 rows of data in a column with the same syntax. The string of text reads "Director, Business Systems Analyst Director" I want to copy the text into an adjacent column without the first word so it reads "Business Systems Analyst Director". The length of the first word is exactly the same in each row, however the text string after the first word varies. Any Ideas?
Try this
Formula:
Please Login or Register to view this content.
v A B 1 Director, Business Systems Analyst* Business Systems Analyst*
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
tryFormula:Please Login or Register to view this content.
Hi and welcome to the forum
One way (of many)
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Sandy666, this worked thanks much
If there is a comma "," in each cell, then you will be able to siphon the first word from the rest of the string using =TRIM(LEFT(A2,FIND(",",A2)-1)). Do this on B2. The result here will give you Director. Then on C2 put in this =TRIM(MID(A2,FIND(",",A2)+1,LEN(A2))). Finally on D2 concatenate the results of B2 and C2 with =B2&" "&C2
Glad to help
If problem is resolved Add Reputation star to person(s) who helped you and mark thread as Solved . Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks