In F2 there is a space in the beginning of the name because theres no value in B2. The rest works, but just the beginning of the name has a space. I made this formula, but it doesnt seem to work. Any way it works for both rows 2 and 3? Thanks!
=IF(B2<>"",""&B2,"")& IF(C2<>""," "&C2,"") & IF(E2<>""," "&E2,"") & IF(A2<>""," "&A2,"")
Space.xlsx
try:Formula:
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...
Works as a charm, thanks +rep
Hi,
Am I missing something or can you not just use:
=TRIM(B2&" "&C2&" "&E2&" "&A2) ?
Regards
Your right, shorter formula, thanks! +rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks