Hey guys,

I have a Column of number ranges that I want to add a prefix to.

Current:
543543-54353543
545435-54354354
213313-32312121
Ect.
Ect.
Ect.


I want it to look like:

ABCDE543543-ABCDE54353543
ABCDE545435-ABCDE54354354
ABCDE213313-ABCDE32312121
Ect.
Ect.
Ect.

The prefix is constant. Any easy way to do this?

Thanks

 

I'd make a second column concatenating the prefix and the first column (I think the formula is CONCAT() ), then copy and paste special --> values from the new column on top of the first. Then delete the new column.

 

Yeah.

 

make a second column with the prefix(ie. abcd) then use this.

Kinda hack job but works. This formula doesn't take column names into account. if you have column names, just change the A1's/B1's to whatever line the data starts on.

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

 

That too.

 

 

What's the purpose of the hyphen-finding?

 

cause you need to prefix 2 different places, at the beginning and after the hypen

 

I need a bigger monitor.

 

Thank guys

 

No prob.