While many SM look forward to working in the civilian sector some day, I thought I get advice from anyone here whom knows Excel.
It doesn't matter what a UUID is nor GUID, this is rather different.
Problem:
In order for me to make a sequence of numbers in a series
Such as : 12345
or columns and have then show up in a different cell with a sequence of numbers: such as 43512
Solution:
I would use the
CONCATANATE (followed by each cell that the item is in that cell in the order I want them placed here)
---------------------------------------------------
New Problem:
That works great with different cells.
But what if I want to do the same using only 1 cell for input and 1 cell for output ?
say :
B19: AE769700
and I want Cell: to show:
B20: 700AE786
What formula do I use?
I don't want to use VBS or visual basics in excel.
If you can help please provide an answer.
I made an attachment
With out getting to technical the UUID (Which can be any number or letter) contains 32 characters. In order to convert that into a guid, these characters must be realigned to fall in the proper order.
In an example If I use Cell B1 through D1 and format that cell to become one, This will be the UUID input.
In cell C1 I would take c1 through c4 formate it to be become 1 cell, This will be the out put.
So what I enter in B1 would be : AE111D11
In Cell c1 the output: I would read : D1111AE1
-----------------------------------------------------------
The above is an example only. So the equation must be in Cell C1.
Now you mentioned something above I haven't tried yet, can you give me the function for the out to read left, right midstring.
By the way thanks for responding because I actually has a spread sheet with the correct formula and because Windows XP got decommission it was disconnected and I lost that spread sheet.
Ok I found the solution I will post it soon. But thanks every one for your help.
First what is a UUID and what is a GUID?
http://en.wikipedia.org/wiki/UUID
http://en.wikipedia.org/wiki/Globally_Unique_Identifier
Solution: Based on the what was needed on the initial topic, the solution is here.
Here is the image to be used to describe the proper settings:
The goal was to enter a UUID into one box and display the guid in another box as a whole.
Give the image shown these are the formulas :
Cell B12 though E12 are formatted to Merge cells
Cell B14 through E 14 are formatted to merge cells.
--------------------------------------------------------------
Cell B12 through E12 remain blank for entry only.
Copy and paste the following in the cells shown:
On cell B14 - E14 : =CONCATENATE(B24,C24,D24,E24,F24,G24,H24,I24,J24)
Copy and paste the following to the cells shown:
B20: =MID($B$12,1,2)
C20: =MID($B$12,3,2)
D20: =MID($B$12,5,2)
E20: =MID($B$12,7,2)
F20: =MID($B$12,9,2)
G20: =MID($B$12,11,2)
H20: =MID($B$12,13,2)
I20: =MID($B$12,15,2)
j20: =MID($B$12,17,16)
Copy and paste the following to the cells shown:
B24: =HLOOKUP(B23,$B$19:$J$20,2,FALSE)
C24: =HLOOKUP(C23,$B$19:$J$20,2,FALSE)
D24: =HLOOKUP(D23,$B$19:$J$20,2,FALSE)
E24: =HLOOKUP(E23,$B$19:$J$20,2,FALSE)
F24: =HLOOKUP(F23,$B$19:$J$20,2,FALSE)
G24: =HLOOKUP(G23,$B$19:$J$20,2,FALSE)
H24: =HLOOKUP(H23,$B$19:$J$20,2,FALSE)
I24: =HLOOKUP(I23,$B$19:$J$20,2,FALSE)
J24: =HLOOKUP(J23,$B$19:$J$20,2,FALSE)
The end product is to be able to type a uuid in one cell and show the results in one cell.
Without using any scripts, VB or macros in cell.
For those interested in testing this, you will note that this works very well.
So with this said solution found :)
I like to conclude by saying Thank you to both
SPC Thundercloud and SPC P K, for your assistance and helpful ideas.
Continue with Facebook 
Continue with Google