Add text to a column based on text in a different column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long column of 4 character letters that I would like to replace in
another column with 3 characters eg AAA1 to AAA. Is there any type of if
statement?
 
In the column that will have the three character version type:

=LEFT(A1,3)

Changing A1 to reflect the first cell that your using in the source column.

To convert the results to values, select the entire column of LEFT function
values, press <Ctrl+C> to copy the data. Then click EDIT in the menu and
select PASTE SPECIAL and click the VALUES option button. Click OK to
complete the paste command.
 
Back
Top