alphabex18
New Member
- Joined
- Dec 28, 2016
- Messages
- 1
I have a cell (A1) that looks like this:
<colgroup><col width="321" style="width: 241pt; mso-width-source: userset; mso-width-alt: 11739;">
<tbody>
</tbody>this is where I am at so far, but I cant seem to rid the additional items within the brackets
=RIGHT(A1,LEN(A1)-(SEARCH(",",A1,1)+1))
&" "
&LEFT(A1,SEARCH(",",A1,1)-1)
Thanks for any help
Last Name, First Name [000100833-RWURL] I need a formula to trim the [000100833-RWURL] , which is always 17 characters with the brackets, and then put the first name first and the last name last with no comma |
=RIGHT(A1,LEN(A1)-(SEARCH(",",A1,1)+1))
&" "
&LEFT(A1,SEARCH(",",A1,1)-1)
Thanks for any help