problem copying this stuff down?

[wannabe_guru]

is there an easier way to get this info copied?

i guess my problem is that, they aren't just one cell space between them, some have multiple some have just one, some have none. is there a way to copy this information into teach cell faster than doing it one by one?

[pre]

14151ABC PROJECT	14151AB

14152ABC PROJECT	14152AB

14153ABC PROJECT	14153AB

14154ABC PROJECT	14154AB

[/pre]

 

[senthilkumar_rm]

Hi


Use this =TRIM(LEFT(H24,7))


Thanks


Senthilkumar_rm

 

[Faseeh]

Hi wannabe_guru,


..Or alternatively you may also use this:

=SUBSTITUTE(A1,"PROJECT","")


..Where A1 contains 14151ABC PROJECT

. BTW senthilkumar_rm's one is better with regard that it leaves no extra spaces before word "PROJECT". Thumbs Up senthilkumar_rm !


Regards,

Faseeh

 

[wannabe_guru]

sorry, i think we missed the mark here by a long shot.


what should happen is the copy down for the project.


i think it was using the copy special functionality for blanks and pasting in the formula.

 

[Montrey]

try this!

=(LEFT(H12,5)+1)&RIGHT(H12,3)


H12, should be the 14151ABC cell. Then just drag down.