Replace spaces with forward slash

[vrn_behl]

Dear friends,

How do i add forward slash (/) between first word and numeric value. For eg. AFRAM/101; AES/151

<TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt: 22052" width=603><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 452pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=603>AFRAM 101 INTRO AF-AM STUDIES </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20>AFRAM 101 INTRO AF-AM STUDIES </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20>AFRAM 214 AFRAM LIT 1745-PRES </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20>AFRAM 272 SOUTH SINCE CVL WAR </TD></TR></TBODY></TABLE><TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt: 22052" width=603><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 452pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20 width=603>AES 151 INT AMER ETH GROUPS </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20>AES 151 INT AMER ETH GROUPS </TD></TR></TBODY></TABLE><TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt: 22052" width=603><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 452pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20 width=603>AES 494 COMMUNITY INTERN</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20>AES 496 HNRS SENIOR THESIS</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20>AES 498 AES SPECIAL TOPICS</TD></TR></TBODY></TABLE>

thanks
Varun

 

[VoG]

Like this?

=SUBSTITUTE(A1," ","/")

 

[Firefly2012]

Vog's probably didn't come out right because of the way your browser treats multiple spaces. This is explicitly doing what he suggested:

=SUBSTITUTE(A1,REPT(" ",3),"/")