I have a column in my spreadsheet called Model#. The format of these model numbers look like this:
T Bold 5000.FX.B
The dots are basically separators. I would like to copy over these model numbers to another column but remove the last dot and whatever that comes after it. For example:
T Bold 5000.FX.B --> T Bold 5000.FX
Bold 2500.GB..B --> Bold 2500.GB.
TM 25.BO.A1.T --> TM 25.BO.A1
How can I do this using a function? There are a lot of model numbers and doing it manually is very hard.
I have been looking at the RIGHT+SEARCH function but couldn't really find a solution.
Thanks in advance.
T Bold 5000.FX.B
The dots are basically separators. I would like to copy over these model numbers to another column but remove the last dot and whatever that comes after it. For example:
T Bold 5000.FX.B --> T Bold 5000.FX
Bold 2500.GB..B --> Bold 2500.GB.
TM 25.BO.A1.T --> TM 25.BO.A1
How can I do this using a function? There are a lot of model numbers and doing it manually is very hard.
I have been looking at the RIGHT+SEARCH function but couldn't really find a solution.
Thanks in advance.
