Cable Forum - Excel question please

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - Excel question please (https://www.cableforum.uk/board/showthread.php?t=33707343)

Mike	31-01-2019 16:10

Excel question please

Hi all

I have hundreds of codes which I need to round down in order to get a VLOOKUP table to recongise them

Codes are P.AT000269.01 etc etc.

Any ideas please on how to get them to P.AT000269

Ie drop the .01

Would be really grateful for any idea rather than spend hours deleting .01 from each code :(

Many thanks for any help and your time

Regards

Mike

---------- Post added at 16:10 ---------- Previous post was at 15:49 ----------

Ah

Found it

=LEFT(A1,LEN(A1)-3)

Mike

Matthew

01-02-2019 23:25

Re: Excel question please

As what you found or could so a search and replace i.e. search for .01 and replace with nothing.

Caspar

07-02-2019 20:13

Re: Excel question please

Hi, try the excel rounddown function:

https://exceljet.net/excel-functions...ddown-function

Cas

Paul	07-02-2019 21:29

Re: Excel question please

Quote:

Originally Posted by Caspar (Post 35982540)

Hi, try the excel rounddown function:

https://exceljet.net/excel-functions...ddown-function

Cas

:eeek:

Caspar

08-02-2019 19:10

Re: Excel question please

Quote:

Originally Posted by Paul M (Post 35982548)

:eeek:

:angel:

All times are GMT +1. The time now is 02:05.