Current location - Education and Training Encyclopedia - Education and training - Excel adds a word to the left and right of each cell.
Excel adds a word to the left and right of each cell.
Use function: CONCATENATE

For example:

A 1 grid content "south gate"

B 1 Enter "(Xi 'an)" for cell contents.

C 1 Formula: = Concatenate (A 1, B 1) C 1 Display: South Gate (Xi 'an)

B 1 cells are automatically filled down, and C 1 cells can also be filled down automatically.

Related articles
  • Chongqing jianda vocational training school Chongqing jianda vocational training school
  • Ground sign-in training
  • The real estate sales manager summed up five excellent model essays at the end of the year.
  • What's the phone number of Antong Driving School?
  • How can academic education and training institutions recruit more students?
  • Excuse me, is Hengyang Normal University's self-taught undergraduate diploma recognized by the state?
  • Xiamen aromatherapy Shi training
  • Brief introduction of headhunting college
  • Where is the children's street dance training class?
  • Is Dongping Leze education good?

    • copyright 2024 Education and Training Encyclopedia All rights reserved