Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Excel question please

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Reload this Page Excel question please
Register FAQ Members List Calendar Mark Forums Read

Excel question please
Reply
 
Thread Tools
Old 31-01-2019, 16:10   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
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
Mike is offline   Reply With Quote
Advertisement
Old 01-02-2019, 23:25   #2
Matthew
cf.mega poster
 
Join Date: Jul 2003
Location: Lincolnshire
Age: 35
Posts: 2,028
Matthew has reached the bronze age
Matthew has reached the bronze ageMatthew has reached the bronze ageMatthew has reached the bronze ageMatthew has reached the bronze ageMatthew has reached the bronze ageMatthew has reached the bronze age
Re: Excel question please
As what you found or could so a search and replace i.e. search for .01 and replace with nothing.
__________________
Matt
Matthew is offline   Reply With Quote
Old 07-02-2019, 20:13   #3
Caspar
Inactive
 
Join Date: Jun 2003
Location: UK
Posts: 4,988
Caspar has reached the bronze age
Caspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze age
Re: Excel question please
Hi, try the excel rounddown function:

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

Cas
Caspar is offline   Reply With Quote
Old 07-02-2019, 21:29   #4
Paul
Dr Pepper Addict
Cable Forum Team
 
Paul's Avatar
 
Join Date: Oct 2003
Location: Nottingham
Age: 61
Services: Flextel SIP : Sky Mobile : Sky Q TV : VM BB (1000 Mbps) : Aquiss FTTP (330 Mbps)
Posts: 27,681
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Re: Excel question please
Quote:
Originally Posted by Caspar View Post
Hi, try the excel rounddown function:

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

Cas
__________________

Baby, I was born this way.
Paul is offline   Reply With Quote
Old 08-02-2019, 19:10   #5
Caspar
Inactive
 
Join Date: Jun 2003
Location: UK
Posts: 4,988
Caspar has reached the bronze age
Caspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze ageCaspar has reached the bronze age
Re: Excel question please
Quote:
Originally Posted by Paul M View Post
Caspar is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:59.

Contact Us - Service Status - Cable Forum - Archive - Privacy Statement - Terms of Service - Top

Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.

Copyright © 2024 Cable Forum Hosted On Hetzner Cloud