Copy/Paste part of a cell?

[bmoore45]

Hey guys,

I want to know how to copy part of a cell and paste it into a new cell.

Example:

a1= 8hAs7c

portion needed: 7c


I used this formula:

=RIGHT(A1,2)

This returns 7c like I want.

However in the next cell I want to source the middle two (As)

And in another cell I want the first two (8h)

How do I go about this?

 

[Nalani]

Is this what you are looking for?

Excel Workbook
	A	B
1	8hAs7c	7c
2		As
3		8h
Sheet1

 

[bmoore45]

Yes thats perfect! Thanks very much!

 

[Nalani]

You're Welcome.

And thanks for the feedback.

Nothing better than a "Thank You"