In my Excel spreadsheet, I have a formula that I use to mask out some of the digits.
I'd like to use it in Power Queries; how can I use this formula to create a custom column?
It gives me LEFT that not recognize.
=Left(A1,5)&"**** **** "&Right(A1,4)
I'd like to use it in Power Queries; how can I use this formula to create a custom column?
It gives me LEFT that not recognize.