View Single Post
  #4   Report Post  
yellow281
 
Posts: n/a
Default


Morrigan Wrote:
Try this

=CONCATENATE(LEFT(B1,FIND(A1,B1,1)-1),MID(B1,FIND(A1,B1,1)+LEN(A1)+1,LEN(B1)-FIND(A1,B1,1)+LEN(A1)))


Hope it helps.


Can I say genius.. :)

Thank you, it worked brilliantly... I cant quite there was a formula
for this!

May I challenge you again? My B column has up to 12 sets of codes each
seperated by a space in each cell. Is there a way I can tell the B
column to select the first 4 codes to retain them then delete the rest?
And if theres 4 codes or less to just leave the cell intact?

For example..

Before

B Column

*1234 3456 2356 8788* 5555 6789 0978 6342 1224 3244

After

B Column

1234 3456 2356 8788

Thank you!


--
yellow281
------------------------------------------------------------------------
yellow281's Profile: http://www.excelforum.com/member.php...o&userid=25695
View this thread: http://www.excelforum.com/showthread...hreadid=391123