Forum Discussion

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Remove text from column based on another column in same table

I have a table imported daily from the web and it contains two columns , one is name and address and the other is just address I need to extract just the name from the address , by a formula to remo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Pandadev,

    Did you mean to remove the 'text string' stored in the 'address' column from the 'name address' field? If that is the case, you can create a calculated column with SUBSTITUTE function:

    Replaced = SUBSTITUTE([Name Address],[Addresss],"")

    Regards,

    Xiaoxin Sheng

  • Pandadev's avatar
    Pandadev
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    unfortunately not , sometimes it can be like

    Smith, Arnold James

    John & Mary Smith