Needing help with something pretty simple as usual. Want to pull the data after the dash (-).
Example:
Rwilliams - Excel 2000
I want to pull the information after the "-". The number of values varies after the dash.
Needing help with something pretty simple as usual. Want to pull the data after the dash (-).
Example:
Rwilliams - Excel 2000
I want to pull the information after the "-". The number of values varies after the dash.
Nevermind, remember it is text to columns..
maybe ..
=RIGHT(A1,LEN(A1)-FIND("-",A1)-1)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks