Question Locked

Excel sheet-How to increment numbers in the row which is composed of text

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

First, let me explain the appearance of my data
consider the following in different row on a single column(cell only)
A1:
x
y
z
-
-
i wanted to prefix a number with the text
say
A1.
1.x
2.y
in one column cell only
Question here is
if i have n no of text rows here for a single column
and i have to increment only the no
say after 1.x
how can i prefix or increment no in each cell
,text should not be changed?

3 replies

by thumbsup2

You'll need to either number them all by hand, or put all of the numbers and letters into their own unique columns on another sheet and use the CONCATENATE function to put them together in the column and sheet you want them to appear in. Even using the CONCATENATE function, you're going to have a lot of hand coding because it may not copy down properly.

This discussion is closed to new replies.