I am arranging some complicated data and I need help in doing this as there are close to 15,000 rows of data.
#1
Current Data in a cell: 1,2,3,4,5
Desired Data in a cell: AB1,AB2,AB3,AB4,AB5
How can I achieve this result? Thank you in advance
I am arranging some complicated data and I need help in doing this as there are close to 15,000 rows of data.
#1
Current Data in a cell: 1,2,3,4,5
Desired Data in a cell: AB1,AB2,AB3,AB4,AB5
How can I achieve this result? Thank you in advance
Welcome to the forum!
How about this (assuming the first cell with 1 in it is A1):
="AB"&A1
Drag copy down.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Or if that is all in one cell
="AB"&SUBSTITUTE(A1,",",",AB")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks