Forum Discussion

Pandadev's avatar
Pandadev
Post 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

Anonymous's avatar
Anonymous
Not applicable
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