Copy a column in worksheet with a character change

P

photowiz

HI
Is there a way to copy the contents of one column to another, but change say
the fifth character of each cell to a different character? For instance, I
have a value of MLPM1 in a column (in each cell) with repetitive data and
want to copy that column but change the 5th character to "2" so that it reads
MLPM2-(data). Can anybody help? Thanks in advance!

Scott
 
K

Ken Wright

With your data in A1:A1000, in say B1

=LEFT(A1,4)&"2"&RIGHT(A1,LEN(A1)-5)

and copy down. Just change what's between the " " for what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Consolidation Table from Different Excel Tabs with Different Format 1
Embed the same Excel multiple times 0
Table Preferred width is changed when pasting 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Hide columns based on row values 2
Countif Limitations 5
Find text in cell and copy from 4 characters in front of the found text. 2

Top