Removing Number/Period/BlankSpace from cells in Column B

[mlarson]

Hi there, I absolutely love this message board. A lot of highly skilled people that contribute. Thanks in advance for taking a look at this one. I'd like a formula that accomplishes the following...

For any cell in Column B, if it starts with a number then a period then a blank space, I would like that number, period, and blank space deleted... but the other contents of the cell remain. Formula/results to go in Column A. For example...

B7 is "243. Cheeseburger", then A7 result is "Cheeseburger"
B44 is "9. Washington", then A44 is "Washington"
B74 is "7 Blue", then no change to A74 (because there was no period after the number)
B95 is "1234.Green", then no change to A95 (because there was no space after the period)
B108 is "Yellow 874." then no change to A108 (because it doesn't start with a number then period then blank space)

I hope this is enough info. Thanks for your help!

 

[mlarson]

UPDATE: nevermind, I think I found a workaround. I used Find "1. " and replaced with ". ", then find "2. " and replace with ". " etc. And then Find ". " and replace with blank.

 

[Rick Rothstein]

If the only time you have a period followed by a space is if a number is in front of it, and if that can only occur at the beginning of the text, then you can select the entire column, and replace this...

"*. "

without the quote marks with the blank.

Note: Your update idea won't work when the number in front of the period has more than one digit in it.

 

[mlarson]

Thank you, Rick! Appreciate you guys.