How do you rearrange words in a cell in excel. For example I have:
"The anatomy of Humans"
How could I change that to
"Anatomy of Humans, The" ?????
How do you rearrange words in a cell in excel. For example I have:
"The anatomy of Humans"
How could I change that to
"Anatomy of Humans, The" ?????
Entia non sunt multiplicanda sine necessitate
See this
=IF(LEFT(A1,3)="The",MID(A1,5,999)&", The",IF(LEFT(A1,2)="a ",MID(A1,3,999)&", A",A1))
and another thread discussing it is here http://www.excelforum.com/excel-gene...nge-words.html
Tough call, will there always be the word "The" at the beginning?
=MID(A1,4,LEN(A1)-4)&" ,"&LEFT(A1,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks