+ Reply to Thread
Results 1 to 6 of 6

How can I get specific text to automatically copy from one to to another?

  1. 01-19-2017, 11:58 AM #1
    eemmiillyy
    eemmiillyy is offline
    Registered User
    Join Date
    01-19-2017
    Location
    nowhere, nowhere
    MS-Off Ver
    2016
    Posts
    2

    How can I get specific text to automatically copy from one to to another?

    Hi everyone!

    I have a spreadsheet which includes names as below:

    Hotel A Bournemouth
    Hotel B Morecombe
    Hotel C Bognor Regis
    Hotel A Bournemouth
    Hotel A Bournemouth
    Hotel C Bognor Regis

    etc

    Does anyone know how I can make the town (i.e. Bournemouth, Morecombe, Bognor Regis) automatically pull through into the cell to the right? E.g:

    Hotel A Bournemouth Bournemouth
    Hotel B Morecombe Morecombe
    Hotel C Bognor Regis Bognor Regis
    Hotel A Bournemouth Bournemouth
    Hotel A Bournemouth Bournemouth
    Hotel C Bognor Regis Bognor Regis

    Thanks in advance for any help!!

    Emily
    Reply With QuoteRegister To Reply
  2. 01-19-2017, 12:05 PM #2
    Pete_UK
    Pete_UK is online now
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: How can I get specific text to automatically copy from one to to another?

    Assuming the town name is in column B, you can put this formula in C1:

    =IF(B1="","",B1)

    then copy down.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 01-19-2017, 12:12 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: How can I get specific text to automatically copy from one to to another?

    If you are asking about extracting the town name from the cell, then you need to give us more realistic sample data. Is the town always the last word or words in the text string? Is it always preceded by a space?
    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.
    Reply With QuoteRegister To Reply
  4. 01-19-2017, 12:13 PM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How can I get specific text to automatically copy from one to to another?

    We're assuming your data is already in two columns. Hotel name in A and Town in B, rather than all the text in column A???
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  5. 01-19-2017, 12:30 PM #5
    eemmiillyy
    eemmiillyy is offline
    Registered User
    Join Date
    01-19-2017
    Location
    nowhere, nowhere
    MS-Off Ver
    2016
    Posts
    2

    Re: How can I get specific text to automatically copy from one to to another?

    Hi, thanks for your help so far. The hotel name and town name are both in column A, and yes the town name is always the last word.
    Reply With QuoteRegister To Reply
  6. 01-19-2017, 12:35 PM #6
    Pete_UK
    Pete_UK is online now
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: How can I get specific text to automatically copy from one to to another?

    Quote Originally Posted by eemmiillyy View Post
    ... and yes the town name is always the last word ...
    Unless you have Bognor Regis, in which case it is the last two words. And what about somewhere like Ashby de la Zouch ?

    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 10:59 AM
  2. [SOLVED] Automatically copy specific data from one spreadsheet to a different specific worksheet
    By kelcowcow in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-14-2014, 01:47 AM
  3. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  4. Programming to automatically send text to specific sheets and specific columns.
    By GlobalExcelller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2014, 10:07 PM
  5. If cell contains specific text automatically copy row to different sheet
    By donnzi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2013, 03:41 AM
  6. [SOLVED] Automatically concatenate text in cells containing specific text
    By cmaunder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 06:12 PM
  7. Automatically change the text to multi color in the cell when use a specific text
    By Underworld in forum Excel General
    Replies: 0
    Last Post: 03-12-2013, 04:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1