Pull only 3 digits out of one cell and place

[Captain Randy]

I have cells with 7 digits in each cell.
I want to pull the first, four and sixth digit out of these cells and place them in the cell next to it. (like copy and paste)

Is there a formula that I can use?

Thank You in advance for help.
Randy

 

[danzon]

A1 has your 7 digit number

=LEFT(A1,1)&MID(A1,4,1)&MID(A1,6,1)

 

[rudfaden]

Maybe this

=MID(A1;1;1) & MID(A1;4;1) & MID(A1;6;1)

 

[T. Valko]

I have cells with 7 digits in each cell.
I want to pull the first, four and sixth digit out of these cells and place them in the cell next to it. (like copy and paste)

Is there a formula that I can use?

Thank You in advance for help.
Randy

Try this...

A1 = 1234567

Entered in B1:

=--(LEFT(A1)&MID(A1,4,1)&MID(A1,6,1))

Will return 146 (as a numeric number)

If your strings might start with leading zeros:

A1 = 0234567

Then use this version but be aware that this version returns a TEXT string:

=LEFT(A1)&MID(A1,4,1)&MID(A1,6,1)

 

[West Man]

If you need the result to be a number just add+0 to the above formula

 

[Captain Randy]

Just want to Say "THANK YOU guys for your help !!! This works great...

If you need to know something, just ask the pro's

Thanks to danzon, rudfaden, T Valko, West Man

This is why, this room is so great, lots of good helping guys in here!!!

 

[T. Valko]

Just want to Say "THANK YOU guys for your help !!! This works great...

If you need to know something, just ask the pro's

Thanks to danzon, rudfaden, T Valko, West Man

This is why, this room is so great, lots of good helping guys in here!!!

You're welcome. Thanks for the feedback!