Re: Q for guys who create Excel sims
Hopefully the data source that you are querying is formatted such that you won't need to both refresh and redo the columns. If not, I would first recommend using a new data source. If that isn't an option, try playing around with the "Text" functions. Use functions such as =find, =search, =mid, =left, =right. You should be able to get just about any data formatted properly with these functions.
|