This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a column with names, but they are all preceded by five characters I wish to be deleted:
FIN # Bank of KY
FIN # Bank of the Ozarks
I wish it to only read only "Bank of KY" or "Bank of the Ozarks" (with no spaces in front of it). If I do a find/replace, it leaves a space, so I am not sure how to proceed.
Can you help?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
As stated, I didn't want an extra space, I wanted it to be flush with the left side. I did however, determine the formula I needed to use is:
=RIGHT(B2,LEN(B2)-6)
As stated, I didn't want an extra space, I wanted it to be flush with the left side. I did however, determine the formula I needed to use is:
=RIGHT(B2,LEN(B2)-6)
If you insist on doing it with a formula, you can reduce the number of function calls by doing it this way...
=MID(B2,6,99)
That 99 assumes your text will never be longer than 99 characters. If it could be longer, then just make the 99 a number equal to, or larger than, the maximum number of characters you ever expect to have.HOWEVER, with that said, I would not use a formula... go back to the Edit/Replace and do what Rik_UK posted and note the space after the # sign in his "find" text... by including that space (at that position) in the "find" field, it will get replaced just like any other character you specify there.... hence, so "extra space" afterwards. Try it.
NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.
Hi Dawn
Do a find and replace with an extra space 'FIN # '
Should sort it out...
Rik_UK Please mark the message or messages that answer your question as the "Answer" or vote if a reply has been helpful.
THANKS A LOT
Yours is not the best solution. Reread the previous post
Don Guillett MVP Excel SalesAid Software *** Email address is removed for privacy ***