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!
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!