Move Text From End Of String To Beginning
I have a column which contains a series of alphanumeric characters some start with the alpha characters and others end with them. As an example
ABS1234, 1234ABS, 12k34AB needs to be ABS1234, ABS1234, AB12k34. The number of alpha characters at the end will be a minimum of 2 and a maximum of 3. Is there some way that I can move the Alpha characters, at the end, so that they are always at the beginning of the string? Thanks
is the string always 7 characters?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for looking into this. In answer to the question no, the length will vary between 8 and 17 characters
Hi,
A bit of a mouthful and you could break it down into helper cells which would aid readability but in one cell
Formula:
Please Login or Register to view this content.
Last edited by Richard Buttrey; 06-28-2013 at 06:12 AM. Reason: typo in formula
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.
maybe
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks