UUID to GUID excel - I need help with this.

2014-03-09T21:32:02-04:00

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

Response by SGT Private RallyPoint Member made Mar 13 at 2014 9:47 PM

2014-03-13T21:47:45-04:00

SSG Pabon,

This is interesting. What happens when you concatenate directly from the source cells? Example: =CONCATENATE(E15,D15,C15,B15,G15,F15,I15,H15)

2014-04-08T00:21:37-04:00

Ok I found the solution I will post it soon. But thanks every one for your help.