Adding In Forward Slashes After text (/)

[AV1D]

Hi All,

Im currently working on something and im in need of some help in getting excel to populate a /1 after defiend text, however this should change in each cell such as.


exmple:

(D1)88987

(A4)=IF(D1="","",D1) which inserts 88987 unless blank, however i need this to go as 88987/1
then
(A5)=IF(D1="","",D1) 88987/2

And so forth

I have tired custom format in which i can get it go to 00000/0 which shows 00000/1 however doesnt change the /1 in the next cell and so on.

Does anyone know a way of getting the / to populate and to change the end numeber in each cell.

Thanks in advance

AV1D

[Richard Buttrey]

Hi,
and welcome to the forum

=IF($D$1="","",$D$1)&"/"&ROW()-3

[Fotis1991]

Hi and welcome to the forum.

Try something like this.

=IF($D$1="";"";$D$1&I1) >>Copy down.>> I, is a helper column.

Hope to helps you.

[AV1D]

Thanks guys these are awesome tbh,

I went with Richards code, however i had to change it slightly from:

=IF($D$1="","",$D$1)&"/"&ROW()-3

to

=IF($D$1="","",$D$1)&"/"&ROW()-14

to allow it to start at 1.

Heres another one for you.

TEST1 = Sheet name

=IF(TEST1!C4="Partics","FILTER"&TEST1!C6) which looks at TEST1 to see if cell has Partics, C6= a number (ie.. 325) (in which is used to track what filter was used),,

It then populates SHEET1!D5 with, FILTER325 is there anyway to tell the function to add a space in which creates FILTER 325??


Thanks

AV1D

[Haseeb Avarakkan]

Hello AVID,

Just add a space after FILTER

"FILTER "&TEST1!C6

[AV1D]

Ahh, dam why didnt i think of that