LinkBack URL
About LinkBacks
Hi, I'm trying to find a formula to add spaces in between capitalized words
example :
cell A1 = MtVernonRoad
trying to make it say..
Mt Vernon Road
any help would be awesome. I'm stumped. thanks
Hi, I'm trying to find a formula to add spaces in between capitalized words
example :
cell A1 = MtVernonRoad
trying to make it say..
Mt Vernon Road
any help would be awesome. I'm stumped. thanks
so this works for this example, but it is not dynamic for others....unless the whole data set follows this format...
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
A small UDF will work:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Much thanks OllyXLS , But I'm only familiar with functions that start with = . What is a UDF? I'll look it up on here and try to learn about them. thanks
UDF = User Defined Function.
You need to paste that code into a module of your workbook:
- Open the Visual Basic Editor (You're on Excel 2011 for Mac, right? See this link for details of how to do this step)
- Click Insert > Module
- Paste my code into the blank module that appears (Module1)
You may now close the Visual Basic Editor, to return to your workbook.
You can then use the function in your workbook, as a formula:
Formula:
Please Login or Register to view this content.
amazing , thank you OllyXLS . I'll try it
I couldn't try the UDF because I the section where I needed to paste it gave an error. I did dsome research and it looks like I somehow did not install VBA when I initially installed Excel years back . So, I'll try and remedy that and then try it and report back. Much Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks