ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a worksheet which when you enter 7 characters the calculator does its magic & then returns a much longer number.
I havent seen anything like this before but below is some of the code to explain to you what its all about & hoping somebody will understand what i have here as im lost on how to explain it.
Brief example of what i see.
You input 7 characters on sheet 1 & the lookup database is on sheet 2.
Database Column B is numbers from 0-42
Database Column A is 0-9 followed by A-Z followed by 7 character symbols.
I need to be able to copy the data of which is that long number 18 characters & there is 4 of them,paste these values into a excel sheet so i can then email it.
Any member know of this code & might be able to help.
Thanks
I have a worksheet which when you enter 7 characters the calculator does its magic & then returns a much longer number.
I havent seen anything like this before but below is some of the code to explain to you what its all about & hoping somebody will understand what i have here as im lost on how to explain it.
Code:
=CONCATENATE("*",UPPER(E7),UPPER(E6),UPPER(F6),UPPER(G6),UPPER(H6),UPPER(I6),UPPER(J6),E19,"FF",E23,"*")
Brief example of what i see.
You input 7 characters on sheet 1 & the lookup database is on sheet 2.
Database Column B is numbers from 0-42
Database Column A is 0-9 followed by A-Z followed by 7 character symbols.
I need to be able to copy the data of which is that long number 18 characters & there is 4 of them,paste these values into a excel sheet so i can then email it.
Any member know of this code & might be able to help.
Thanks